Home > IT Answers > Oracle > Slowdown in SQL Restore on SQL Server 2000
SQL Server Ask the Experts
2,585 pts.
 Slowdown in SQL Restore on SQL Server 2000
Enterprise Manager, SQL Enterprise Manager, SQL Restore, SQL Server 2000, 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?

Software/Hardware used:
ASKED: February 27, 2009  4:34 PM
UPDATED: February 27, 2009  6:58 PM
RELATED QUESTIONS
Answer Wiki:
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.
Last Wiki Answer Submitted:  February 27, 2009  6:58 pm  by  Denny Cherry   64,550 pts.
All Answer Wiki Contributors:  Denny Cherry   64,550 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _