Backup syntax

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

TDPSQLC backup

Read syntax diagramSkip visual syntax diagramTDPSQLCBackup ,dbname* FULL?COPYFullFIle=,logicalfilename*DifffullAGroup=,groupname*LogBSetC

Backup optional parameters

Read syntax diagramSkip visual syntax diagram12/AAGName=AlwaysOn Availability Group name/ADJUSTKBtsmestimate=numkb/ADJUSTPERcenttsmestimate=numpercent/ALWAYSONPriority/BACKUPDESTination=TSMLOCALBOTH/BACKUPMETHod=LEGACYVSS/BUFFers=3 [or cfg value]?=numbuffers/BUFFERSIze=1024 [or cfg value]?=buffersizeinkb/CONFIGfile=tdpsql.cfg?=configfilename/ENABLEREPlacementchars=No?=Yes/EXCLUDEdb,=dblist,.../EXCLUDEALwaysondbs/EXCLUDESTandarddbs/LOGFile=tdpsql.log [or cfg value]?=logfilename/LOGPrune=60 [or cfg value]?=numdays=No/OFFLOAD/Quiet/SQLAUTHentication=INTegrated [or cfg value]?=SQLuserid/SQLBUFFers=0 [or cfg value]?=numsqlbuffers/SQLBUFFERSIze=1024 [or cfg value]?=sqlbuffersizeinkb/SQLCHECKSum=No?Yes/SQLCOMPression=No?=Yes/SQLPassword=" "?=sqlpasswordname/SQLSERVer=[local computer name or cfg value]?=sqlserver-connection/SQLUSer=sa?=sqlusername/STRIPes=1 [or cfg value]?=numstripes/TSMNODe=[dsm.opt value]?=tsmnodename/TSMOPTFile=dsm.opt?=dsmoptfilename/TSMPassword=[dsm.opt value]?=tsmpasswordname/USEALWAYSONnode
A Difffull Options
Read syntax diagramSkip visual syntax diagram/DIFFESTimate=20 [or cfg value]?=numpercent
B Log Options
Read syntax diagramSkip visual syntax diagram/TRUNCate=Yes?=No/LOGESTimate=0?=numpercent/BACKUPTAILLOG
C Set Options
Read syntax diagramSkip visual syntax diagram/FIles=,logicalfilename*/GRoups=,groupname*
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 issue 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.