Results 1 to 3 of 3

Thread: List of backups

  1. #1
    Join Date
    Sep 2003
    Location
    Hertfordshire, England
    Posts
    78

    Question Unanswered: 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.

  2. #2
    Join Date
    Mar 2003
    Location
    Reading, UK
    Posts
    70
    Try deleting it from backupset table from ur msdb database.

  3. #3
    Join Date
    Sep 2003
    Location
    Hertfordshire, England
    Posts
    78
    Thanks this looks like the answer I am looking for.

    Neil.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •