Set syntax

Edit online

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

Figure 1. TDPSQLC command

1  TDPSQLC  Set
1  ALWAYSONNode= nodename
1  BACKUPDESTINATION=
2.1! TSM
2.1 LOCAL
2.1 BOTH
1  BACKUPMETHOD=
2.1! LEGACY
2.1 VSS
1  BUFFers= numbuffers
1  BUFFERSIze= buffersizeinkb
1  DATEformat= dateformatnum
1  DIFFESTimate= numpercent
1  LANGUAGE= 3-letter country code
1  FROMSQLserver= fromsqlserver
1  IMPORTVSSSNAPSHOTSONLYWhenneeded=
2.1 Yes
2.1 No
1  LOCALDSMAGENTNODE= nodename
1  LOGFile= logfilename
1  LOGPrune=
2.1 numdays
2.1 No
1  NUMBERformat= numberformatnum
1  MOUNTRW=
2.1! No
2.1 Yes
1  MOUNTWaitfordata=
2.1 Yes
2.1 No
1  REMOTEDSMAGENTNODE= nodename
1  SQLAUTHentication=
2.1 INTegrated
2.1 SQLuserid
1  SQLBUFFers= numsqlbuffers
1  SQLBUFFERSIze= sqlbuffersizeinkb
1  SQLCHECKSum
2.1 =Yes
2.1 
2.1! =No
1  SQLCOMPression
2.1 =Yes
2.1 
2.1! =No
1  SQLSERVer= sqlprotocol:sqlservername
1  STRIPes= numstripes
1  TIMEformat= timeformatnum
1  USESNAPOFASNAPTOMount=
2.1 No
2.1 Yes
Figure 2. Set Optional Parameters

1?  /CONFIGfile
2.1! =tdpsql.cfg
2.1 
2.1 =configfilename