September 7, 2006 at 10:52 am
Hi -- I am trying to put together a script to perform automatic backups. I would like to use the "NOINIT" parameter to append the backups, in case we need to go back further than the last backup.
My question is: is there any way to restore from a backup like that without using the FILE=<file number> parameter? Like, is it possible to specify a name for a backup set within a file, so you do not have to know exactly which number the backup set is within the file?
Or, alternatively, is there a way of looking at the structure of the backup file to see how many backup sets are in it, the date of each one, and its number?
I can foresee a situation where I want to restore from the last backup set in the file, but I don't know the number of it. I can't seem to find any documentation about this.
Thanks!
Cynthia
September 7, 2006 at 11:25 am
Check out RESTORE FILELISTONLY and RESTORE HEADERONLY in the BOL.
-SQLBill
September 7, 2006 at 11:47 am
OK, RESTORE HEADERONLY seems to be what I'm looking for. Thanks!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply