Backup syntax

Edit online

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

Figure 1. TDPSQLC backup

1  TDPSQLC  Backup
2.1 + , dbname
2.1 *
1! FULL
1 
1  COPYFull
1  FIle=
2.1 + , logicalfilename
2.1 *
1  Difffull %A
1  Group=
2.1 + , groupname
2.1 *
1  Log %B
1  Set %C
Figure 2. Backup optional parameters
(1)
A Difffull Options

1?  /DIFFESTimate
2.1! =20 [or cfg value]
2.1 
2.1 =numpercent
B Log Options

1?  /TRUNCate
2.1! =Yes
2.1 
2.1 =No?  /LOGESTimate
2.1! =0
2.1 
2.1 =numpercent?  /BACKUPTAILLOG
C Set Options

1+ 
1  /FIles=
2.1 + , logicalfilename
2.1 *
1  /GRoups=
2.1 + , groupname
2.1 *
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.