SQL Restore takes 6-10 minutes to come up in Enterprise Manager
MySQL Restore, SQL 2000, SQL Enterprise Manager, SQL performance, SQL Restore, SQL Restore Performance, Windows 2000 Server
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.
Software/Hardware used:
Software/Hardware used:
ASKED:
February 17, 2009 2:52 PM
UPDATED:
February 17, 2009 6:58 PM
Answer Wiki:
check out msdb.dbo.sp_delete_backuphistory
My guess is your msdb is full of backup history. When you use the GUI it is reading through all of the history.
Create a SQL agent job to run daily and trim the history back 30 or 90 days.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
