question

John 5 1 avatar image
John 5 1 asked

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

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.

sql-server-2000transaction-log
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.