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.