Slowdown in SQL Restore on SQL Server 2000
Home > IT Answers > SQL Server > Slowdown in SQL Restore on SQL Server 2000
SQL Server Ask the Experts
2445 pts.
0
Q:
Slowdown in SQL Restore on SQL Server 2000
SQL Server 2000, SQL Restore, Enterprise Manager, SQL Enterprise Manager, 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?
ASKED: Feb 27 2009  4:34 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46765 pts.
0
A:
 RATE THIS ANSWER
+1
Click to Vote:
  •   1
  •  0
  • AddThis Social Bookmark Button
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 Answered: Feb 27 2009  6:58 PM GMT by Mrdenny   46765 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0