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?