Home > IT Answers > SQL Server > Switching from Bulk-Logged to Simple Recovery Model on SQL Server 2000
John0990
5 pts.
 Switching from Bulk-Logged to Simple Recovery Model on SQL Server 2000
SQL Server 2000, SQL Server transaction logs, Transaction logs
Hello, I've got a SQL Server 2000 SP4 database that I am considering switching from Bulk-Logged to Simple recovery model. The reason is, there are no transaction log backups happening so the log is just growing to an unmanageable size (40+ GB). I also want to minimize/shrink the log file. What is the easiest (but safe) method to do this? Can I use Enterprise Manager to detach the database and delete the log file, then reattach and switch to Simple model? (Will a new log file automatically be created?) Thanks in advance.

Software/Hardware used:
SQL Server 2000 SP4
ASKED: February 24, 2010  4:52 PM
UPDATED: February 24, 2010  10:48 PM
RELATED QUESTIONS
Answer Wiki:
NEVER delete the log file. Simply change the database from bulk logged to simple. Then you can shrink the log file down. If you log file is growing simply being doing log backups on it and it won't grow out of control any more.
Last Wiki Answer Submitted:  February 24, 2010  10:48 pm  by  Denny Cherry   64,550 pts.
All Answer Wiki Contributors:  Denny Cherry   64,550 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _