Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
WSUS templog.ldf
- Thread starter bentley45
- Start date
mrdenny
Programmer
- May 27, 2002
- 11,595
This is the transaction log for the temporary database. When ever the sus database is being reindexed this file is used.
The easyist way for me to help you shrink the file is to actually restart the server. This file is automatically deleted and recreated each time sql server starts.
If you know how to restart WSUS manually you can restart the sql services and the WSUS services.
If you can't bring the the system down let me know, and I'll give you the sql command to shrink the file manually.
Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)
--Anything is possible. All it takes is a little research. (Me)
![[noevil]](/data/assets/smilies/noevil.gif "[noevil] [noevil]")
The easyist way for me to help you shrink the file is to actually restart the server. This file is automatically deleted and recreated each time sql server starts.
If you know how to restart WSUS manually you can restart the sql services and the WSUS services.
If you can't bring the the system down let me know, and I'll give you the sql command to shrink the file manually.
Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)
--Anything is possible. All it takes is a little research. (Me)
- Thread starter
- #3
mrdenny
Programmer
- May 27, 2002
- 11,595
No problem.
When you've got SQL Problems check out forum962.
Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)
--Anything is possible. All it takes is a little research. (Me)
When you've got SQL Problems check out forum962.
Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)
--Anything is possible. All it takes is a little research. (Me)
- Status
Similar threads
- Locked
- Question
- Locked
- Question