Sunday, August 29, 2010

How to shrink SQL logs

Just want to inquire on how to shrink my sql logs.
My disk space is running and I suspect that sql logs is the cause
of the problem..
Answer:
BACKUP LOG WITH TRUNCATE_ONLY will empty your log file (depending on recovery model) , but if you then want to make the log file smaller, you will have to use DBCC SHRINKFILE

No comments:

Post a Comment