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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!