Home Forums SQL Server 7,2000 SQL Server Agent Shrinkdatabase job running via the SQL Server Agent RE: Shrinkdatabase job running via the SQL Server Agent
David A. Long
SSCrazy Eights
Points: 8421
More actions
June 23, 2005 at 1:46 am
#567778
Go to BOL, Shrinking the Transaction Log:
mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\architec.chm::/8_ar_da2_1uzr.htm
Change your DBCC statement to:
DBCC SHRINKDATABASE (tempdb, 10) WITH NO_INFOMSGS
Andy