Backup syntax

Use the backup command syntax diagrams as a reference to view available options and truncation requirements.

Read syntax diagramSkip visual syntax diagram
TDPSQLC command

                                .-FULL-----.   
>>-TDPSQLC--BACKup----dbname----+-COPYFull-+-------------------><


Read syntax diagramSkip visual syntax diagram
Backup optional parameters

    (1)   (2)   
>>-------------------------------------------------------------->

>--+-------------------------------------------------+---------->
   '-/AAGName----=AlwaysOn Availability Group name---'   

>--+-------------------+---------------------------------------->
   '-/ALWAYSONPriority-'   

>--+-----------------------------------+------------------------>
   |                      .-LOCAL----. |   
   '-/BACKUPDESTination=--+-+-----+--+-'   
                          | '-TSM-'  |     
                          '-+------+-'     
                            '-BOTH-'       

>--+----------------------------+------------------------------->
   |                 .-LEGACY-. |   
   '-/BACKUPMETHod=--+--------+-'   
                     '-VSS----'     

>--+----------------------------------+------------------------->
   |              .-=tdpsql.cfg-----. |   
   '-/CONFIGfile--+-----------------+-'   
                  '-=configfilename-'     

>--+-----------------------------------+------------------------>
   |                          .-=No--. |   
   '-/ENABLEREPlacementchars--+------+-'   
                              '-=Yes-'     

>--+----------------------------------+------------------------->
   |               .-,------------.   |   
   |               V              |   |   
   '-/EXCLUDEdb------=db-name,...-+---'   

>--+---------------------+--+---------------------+------------->
   '-/EXCLUDEALwaysondbs-'  '-/EXCLUDESTandarddbs-'   

>--+----------------------------------+------------------------->
   |              .-=dsm.opt--------. |   
   '-/FCMOPTFile--+-----------------+-'   
                  '-=dsmoptfilename-'     

>--+------------------------------------------+----------------->
   |           .-=tdpsql.log [or cfg value]-. |   
   '-/LOGFile--+----------------------------+-'   
               '-=logfilename---------------'     

>--+-----------------------------------+--+----------+---------->
   |            .-=60 [or cfg value]-. |  '-/OFFLOAD-'   
   '-/LOGPrune--+--------------------+-'                 
                +-=numdays-----------+                   
                '-=No----------------'                   

>--+--------+--------------------------------------------------->
   '-/Quiet-'   

>--+----------------------------------------------------+------->
   |                     .-=INTegrated [or cfg value]-. |   
   '-/SQLAUTHentication--+----------------------------+-'   
                         '-=SQLuserid-----------------'     

>--+------------------------+----------------------------------->
   |                .-No--. |   
   '-/SQLCHECKSum=--+-----+-'   
                    '-Yes-'     

>--+------------------------------------+----------------------->
   |               .-=" "-------------. |   
   '-/SQLPassword--+------------------+-'   
                   '-=sqlpasswordname-'     

>--+-----------------------------------------------------+------>
   |             .-=[local computer name or cfg value]-. |   
   '-/SQLSERVer--+-------------------------------------+-'   
                 '-=sqlprotocol:sqlservername----------'     

>--+----------------------------+--+------------------+--------><
   |           .-=sa----------. |  '-/USEALWAYSONnode-'   
   '-/SQLUSer--+--------------+-'                         
               '-=sqlusername-'                           

Log Options

|--+---------------------+--+-------------------------------+--->
   |            .-=Yes-. |  |               .-=0----------. |   
   '-/TRUNCate--+------+-'  '-/LOGESTimate--+-------------+-'   
                '-=No--'                    '-=numpercent-'     

>--+----------------+-------------------------------------------|
   '-/BACKUPTAILLOG-'   
Notes:
  1. For the optional parameters, the /BACKUPMETHod= is only valid when using the full or copyfull positional parameters. The full and copyfull backups can be performed using VSS or legacy operations. The /BACKUPMETHod= parameter is used to choose between the options. The log, diff, file, and group backups can be performed only when using legacy operations. You cannot specify the /BACKUPMETHod= parameter with these types of backups because only legacy backups are viable.
  2. The /BACKUPDESTination parameter is valid only when using the full or copyfull positional parameters. The full and copyfull backups can be saved to local storage, TSM server storage, or both. The /BACKUPDESTination parameter is used to choose among the options.