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.
February 17, 2009 2:52 PM
February 17, 2009 6:58 PM