Shrinking the Transaction Log File
September 25, 2007 Leave a comment
Seems my database has been a bit busy, scraping comment spam out of the content table and archiving them for future reference. Each scrape and move is a transaction, which gets stored in the transaction log file for the blog database.
I had a disk space issue (i.e., too much trance), a backup failed and the transaction log failed to back up. Upon that failure, the log didn’t get truncated, so it grew out of control.
A quick Bing Search for "sql server shrink database" and I uncovered "How to use the DBCC SHRINKFILE statement to shrink the transaction log file in SQL Server 2005".