Oct
26
2009

SQL Log Files Too Large?

Are you SQL log files getting too large?
Is your SQL server running out of disk space?
Look at you log files, as databases with FULL RECOVERY mode selected can grow out of control…
Use this in Query Analyser
BACKUP LOG DATEBASE
WITH TRUNCATE_ONLY
Then shrink the log file in Enterprise Manger / SQL Server Management Studio
Disclaimer: I do not guarantee that this will solve your problem and any tips listed on this website you use at your own risk

About the Author:

Comments are closed.