Backup Set Position Number...

  • I have several backup sets contained in one file (the result of running same backup statement several times). I'd like to restore from the second one. BOL tells me that I should specify the position number (2) in my resore statement, but doesn't provide the syntax. How would I write it?

    Thank you.

  • I believe it is - "Restore myDB From dbBackup with file = 2"...

    I'm sure BOL has something on this...







    **ASCII stupid question, get a stupid ANSI !!!**

  • here it is...in BOL..RESTORE DATABASE....and in the Topics found listbox - select the very last one - RESTORE for the syntax details...







    **ASCII stupid question, get a stupid ANSI !!!**

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

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