Switching from Bulk-Logged to Simple Recovery Model on SQL Server 2000

5 pts.
Tags:
Microsoft 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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following