Truncate Sqlserver Logs

If the transaction log for your databases is growing without control, you may end up filling the whole hard drive.

In order to reduce the transaction log execute the folowing command:

BACKUP LOG databaseName WITH TRUNCATE_ONLY
dbcc shrinkdatabase(databaseName)
page revision: 0, last edited: 19 Jul 2010 09:09
Edit Tags History Files Print Site tools + Options
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License