SQL Restore takes 6-10 minutes to come up in Enterprise Manager. We have a customer with hundreds of sites, and all their servers do the same thing. We had to roll back after an upgrade and we find that when just selecting "Restore Database" it will seem like Enterprise Manager is hung, but eventually it will finish. Has anyone else seen this, and is there a fix? I'm sure we could run the restore through a script, but I'd like to see what causes the Restore Wizard to hang when launching. This is on SQL 2000, Windows 2000 Server SP4. Server is Intel Xeon 2.8 Ghz with 4gb RAM and free space appears fine.
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!