SQL Restore takes 6-10 minutes to come up in Enterprise Manager
Home > IT Answers > Development > SQL Restore takes 6-10 minutes to come up in ...
Ulukinatme
10 pts.
0
Q:
SQL Restore takes 6-10 minutes to come up in Enterprise Manager
MySQL Restore, SQL Restore, SQL Enterprise Manager, SQL Restore Performance, SQL performance, SQL 2000, 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.
ASKED: Feb 17 2009  2:52 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Barneyrubble318
15 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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.
Last Answered: Feb 17 2009  6:58 PM GMT by Barneyrubble318   15 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0