Truncating the SQL Server's transaction log
August 9th, 2007
If you end up with a full transaction log in your SQL Server's database, you can fix the problem by truncating the transaction log using this small script:
Make sure to replace dbname with your database's name. Thanks to "gel" for the tip. You may need to run the script once or twice (...), that was the exact instructions I was given...
DUMP TRANSACTION dbname WITH NO_LOG;
DUMP TRANSACTION dbname WITH TRUNCATE_ONLY;
DBCC SHRINKDATABASE (dbname, TRUNCATEONLY);Make sure to replace dbname with your database's name. Thanks to "gel" for the tip. You may need to run the script once or twice (...), that was the exact instructions I was given...