November 3, 2011 at 11:16 pm
I'm in the process of creating an automated backup T/SQL script.
I googled this a bit and I'm seeing a "with file" option included as part of the script.
I'm not clear on what these option numbers indicate and if the option numbers are fully represented and consistent for all databases.
Can someone please give me a better understanding of this option?
November 3, 2011 at 11:23 pm
Hi
File Indicants Log and data file, can you publish full script for more detail.;-)
Ali
MCTS SQL Server2k8
November 4, 2011 at 9:21 am
Ali Tailor (11/3/2011)
HiFile Indicants Log and data file, can you publish full script for more detail.;-)
Nevermind - I just noticed that the backup UI has a "Script" button which lets a user save off the script for the current action. That gives me the info I need.
November 4, 2011 at 9:39 am
The backup file may contain multiple backups within the file. "With File=n" clause allows you to restore a particular backup from the file.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply