Use the backup command syntax diagrams
as a reference to view available options and truncation requirements.
TDPSQLC backup
.-,------.
V |
>>-TDPSQLC--Backup--+---dbname-+-+------------------------------>
'-*----------'
.-FULL---------------------------.
>--+--------------------------------+--------------------------><
+-COPYFull-----------------------+
| .-,---------------. |
| V | |
+-FIle=--+---logicalfilename-+-+-+
| '-*-------------------' |
+-Difffull--| A |----------------+
| .-,---------. |
| V | |
+-Group=--+---groupname-+-+------+
| '-*-------------' |
+-Log--| B |---------------------+
'-Set--| C |---------------------'
Backup optional parameters
(1) (2)
>>-------------------------------------------------------------->
>--+-------------------------------------------------+---------->
'-/AAGName----=AlwaysOn Availability Group name---'
>--+----------------------------------+------------------------->
'-/ADJUSTKBtsmestimate----=numkb---'
>--+--------------------------------------------+--------------->
'-/ADJUSTPERcenttsmestimate----=numpercent---'
>--+-------------------+--+--------------------------------+---->
'-/ALWAYSONPriority-' | .-TSM---. |
'-/BACKUPDESTination=--+-------+-'
+-LOCAL-+
'-BOTH--'
>--+----------------------------+------------------------------->
| .-LEGACY-. |
'-/BACKUPMETHod=--+--------+-'
'-VSS----'
>--+---------------------------------+-------------------------->
| .-=3 [or cfg value]-. |
'-/BUFFers--+-------------------+-'
'-=numbuffers-------'
>--+---------------------------------------+-------------------->
| .-=1024 [or cfg value]-. |
'-/BUFFERSIze--+----------------------+-'
'-=buffersizeinkb------'
>--+----------------------------------+------------------------->
| .-=tdpsql.cfg-----. |
'-/CONFIGfile--+-----------------+-'
'-=configfilename-'
>--+-----------------------------------+------------------------>
| .-=No--. |
'-/ENABLEREPlacementchars--+------+-'
'-=Yes-'
>--+---------------------------------+-------------------------->
| .-,-----------. |
| V | |
'-/EXCLUDEdb------=dblist,...-+---'
>--+---------------------+--+---------------------+------------->
'-/EXCLUDEALwaysondbs-' '-/EXCLUDESTandarddbs-'
>--+------------------------------------------+----------------->
| .-=tdpsql.log [or cfg value]-. |
'-/LOGFile--+----------------------------+-'
'-=logfilename---------------'
>--+-----------------------------------+--+----------+---------->
| .-=60 [or cfg value]-. | '-/OFFLOAD-'
'-/LOGPrune--+--------------------+-'
+-=numdays-----------+
'-=No----------------'
>--+--------+--------------------------------------------------->
'-/Quiet-'
>--+----------------------------------------------------+------->
| .-=INTegrated [or cfg value]-. |
'-/SQLAUTHentication--+----------------------------+-'
'-=SQLuserid-----------------'
>--+------------------------------------+----------------------->
| .-=0 [or cfg value]-. |
'-/SQLBUFFers--+-------------------+-'
'-=numsqlbuffers----'
>--+------------------------------------------+----------------->
| .-=1024 [or cfg value]-. |
'-/SQLBUFFERSIze--+----------------------+-'
'-=sqlbuffersizeinkb---'
>--+------------------------+--+---------------------------+---->
| .-No--. | | .-=No--. |
'-/SQLCHECKSum=--+-----+-' '-/SQLCOMPression--+------+-'
'-Yes-' '-=Yes-'
>--+------------------------------------+----------------------->
| .-=" "-------------. |
'-/SQLPassword--+------------------+-'
'-=sqlpasswordname-'
>--+-----------------------------------------------------+------>
| .-=[local computer name or cfg value]-. |
'-/SQLSERVer--+-------------------------------------+-'
'-=sqlprotocol:sqlservername----------'
>--+----------------------------+------------------------------->
| .-=sa----------. |
'-/SQLUSer--+--------------+-'
'-=sqlusername-'
>--+---------------------------------+-------------------------->
| .-=1 [or cfg value]-. |
'-/STRIPes--+-------------------+-'
'-=numstripes-------'
>--+--------------------------------+--------------------------->
| .-=[dsm.opt value]-. |
'-/TSMNODe--+------------------+-'
'-=tsmnodename-----'
>--+----------------------------------+------------------------->
| .-=dsm.opt--------. |
'-/TSMOPTFile--+-----------------+-'
'-=dsmoptfilename-'
>--+------------------------------------+----------------------->
| .-=[dsm.opt value]-. |
'-/TSMPassword--+------------------+-'
'-=tsmpasswordname-'
>--+------------------+----------------------------------------><
'-/USEALWAYSONnode-'
A Difffull Options
|--+---------------------------------------+--------------------|
| .-=20 [or cfg value]-. |
'-/DIFFESTimate--+--------------------+-'
'-=numpercent--------'
B Log Options
|--+---------------------+--+-------------------------------+--->
| .-=Yes-. | | .-=0----------. |
'-/TRUNCate--+------+-' '-/LOGESTimate--+-------------+-'
'-=No--' '-=numpercent-'
>--+----------------+-------------------------------------------|
'-/BACKUPTAILLOG-'
C Set Options
.--------------------------------------.
V |
|----+----------------------------------+-+---------------------|
| .-,---------------. |
| V | |
+-/FIles=--+---logicalfilename-+-+-+
| '-*-------------------' |
| .-,---------. |
| V | |
'-/GRoups=--+---groupname-+-+------'
'-*-------------'
Notes:
- 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
issue the /BACKUPMETHod= parameter with these types of backups because only
legacy backups are viable.
- 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.