• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 367
  • Last Modified:

Restore in Enterprise Manager slow to initialize due to excessive old backups.

I am using SQL Server 2000.  I have been doing a full daily backup for over a year now.  I have the backup job set to delete any old backup files over 7 days old.  When I open the restore database and pick the database I want fo restore from it can take 5 minutes before I can even select the correct date.  Even though the backup files no longer exist the drop down for dates goes all the way back. Is there a way to fix this?
0
abishome
Asked:
abishome
  • 2
1 Solution
 
arbertCommented:
Take a look at the stored proc sp_delete_backuphistory  even though you delete the actual backup files, the history is maintained in MSDB.

Brett
0
 
arbertCommented:
(this proc must be ran from the MSDB database)

Example from books online:

This example deletes all entries older than August 20, 1998, 12:00 A.M., in the backup and restore history tables.

USE msdb
EXEC sp_delete_backuphistory '08/20/98'




Brett
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now