7

SQL Server 2008: Large transaction log file in Simple Recovery Mode

view full story
linux-howto

http://serverfault.com – I am having a problem with disk space in SQL Server 2008. This is the situation: - I had a DB set with Simple Recovery and this DB used to use 2-3 GB for the transaction log file - I moved this DB to a new server and the situation was the same - I changed the recovery mode to FULL and, rightly, the log got 20 GB of disk space - I changed the recovery mode back to SIMPLE and I am not able to shrink the log file back to the 2-3 GB of disk space The log file is very big and is growing fast. I've verified and in the log file there is no room, in fact "available free space" is near 0%. Can anyon (HowTos)