Wednesday, March 7, 2012

List of backups

When I select to restore a database, on the window that pops up you can select from a list what backup you want to resore first. The list im talking about is the one where it says 'First backup to restore'.

Im my list I have the option to restore right back to the year 2003 when my database was first implemented. Now I havn't tried but I know this would not work as I have deleted the backup file associated with those backups in 2003.

Is there anyway I can remove those backups from this list and only show current ones that really exist?

Thanks

Neil.Try deleting it from backupset table from ur msdb database.|||Thanks this looks like the answer I am looking for.

Neil.

No comments:

Post a Comment