Slowdown in SQL Restore on SQL Server 2000

Tags:
Enterprise Manager
Microsoft SQL Server 2000
SQL
SQL Restore
SQL Server performance
We are running SQL Server 2000 on Windows 2000 Server SP4, and our SQL Restore takes at least 10 minutes to launch in Enterprise Manager. We had to roll back after an upgrade, and we find that when selecting "Restore Database", Enterprise Manager runs remarkably slow. 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. Any ideas?

Answer Wiki

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

This is because the SQL Server doesn’t remove the information about the old backups which have been taken.

When you bring up that Window the SQL Server is pulling up the information for every backup that has ever been taken on the aserver. To remove backup history use the sp_delete_backuphistory system stored procedure in the msdb database.

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