Post reply

"Append to media"

  • January 22, 2004 at 1:45 pm

    #106846

    I have a customer who has been backing up to a DISK FILE with APPEND TO MEDIA selected.

    And I'd like to restore the orignal backup and possibly some of the APPENDED stuff.

    A full backup should be about 25Meg and the file they sent me is 34Meg - so I belive there has been some APPENDING going on...

    I'm familair with a normal restore and have been poking at this most of the day

    1) How can I restore the original back up - before anything got appended?

    2) Can I restore the APPENDED stuff also?

     

    Thanks for any help...

    David

     

     

  • January 22, 2004 at 2:13 pm

    #491218

    RESTORE HEADERONLY from disk = 'd:\northwind.bak' command will tell how many backup sets in that media.

    restore database northwind from  disk = 'd:\northwind.bak' with file = 2. 'file = 2' tells you are try to restore second backup set. It comes from column 'position' from RESTORE HEADERONLY command.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply