Posts
463
Comments
319
Trackbacks
1
How to physically shrink a transaction log file

Do NOT do this without a recent backup and only if you are really sure you want to do this, otherwise you could lose data:

USE DbName
GO
EXEC sp_dboption N'DbName', N'trunc. log', N'true'
GO
DBCC UPDATEUSAGE (0)
GO
DBCC SHRINKFILE (DbName_Log, 100, TRUNCATEONLY)

from

posted on Wednesday, March 16, 2005 12:21 PM
Comments
No comments posted yet.

Post Comment

Title *
Name *
Email
Url
Comment *  
Please add 6 and 7 and type the answer here: