Friday, July 08, 2005 1:45 PM
from Frederick.Chapleau

2878 days ago
Viewed 1103 times
Revision 1

Tagged as blog


Printer Friendly Version
PDF Version

Comments?


Log file too big? Wanna shrink?

Home / blog / 2005 / 07 / 08 / Log file too big? Wanna shrink?

First take backup, if it's too big because you don't take it correctly...

... after that, try this ;)

BACKUP LOG database WITH TRUNCATE_ONLY
DBCC SHRINKFILE (log_file,10)






google+