Preston (9/4/2008)
Lynn Pettis (9/3/2008)
Preston (9/3/2008)
What does FILE = 1, NOUNLOAD, & STATS = 10 mean in a Restore statement? Thanks.
Lookup RESTORE in BOL. If you still don't understand, let us know and we will try to clear up any confusion you may have.
😎
OK, read the BOL and it answered 2 of the 3. On the "File = 1", is this the default value? Could I get some examples as to when it would be equal to 2 or 3 and how does the numbering work? Thanks.
Yes, FILE = 1 is the default. You would use FILE = 2 (or some other number) if you append backup files to the same device or file. If you create a new file for every backup (full, differential, or transaction log), then FILE = 1 can be left off the RESTRE command.
Does that help?
😎