SQL Restore takes 6-10 minutes to come up in Enterprise Manager

10 pts.
Tags:
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following