Command-line parameter characteristics

There are several characteristics to take note of in the Data Protection for SQL Server command-line interface:

• Do not include a slash or dash before positional parameters.
• Begin optional parameters with a forward slash (/) or a dash (-).
• You may place multiple optional parameters per command invocation in any order after positional parameters.
• You may abbreviate keywords. Minimum abbreviations are indicated in upper case in the syntax diagrams.
• All SQL names of databases or parts of databases are case-sensitive.
• Separate parameters with at least one space.
• Some keyword parameters may require a value; separate values from their keywords with an equal sign. (=).
• If a parameter's value includes spaces or special characters, enclose the value in double quotes.
• You can use most positional and optional parameters only once per command invocation. The following exceptions allow lists of values or repetition of the parameter:
  • FIle=
  • Group=
  • Log=
  • Set=
  • /FIles=
  • /GRoups=
  • /RELocate=
  • /RELOCATEDir=
  • /TO=
  For example: /files=a,b or /files=a /files=b

  Multiple instances of optional parameters do not have to be contiguous. For example: /files=a /groups=y /files=b /groups=z

Where repeatable syntax appears, separate multiple values with commas as indicated in the following:

                      .-,------.     
                      V        |     
>>-TDPSQLC--Backup--+---dbname-+-+-----------------------------><
                    '-*----------'   

Use the wildcard asterisk (*) following the command to select all instances on the server of database names or file names.