Restore syntax
Use the restore command syntax diagrams as a reference to view available options and truncation requirements.
Syntax
TDPSQLC command
TDPSQLCRestore,dbname*FULL/CONFIGfile=tdpsql.cfg?=configfilename/FCMOPTFile=dsm.opt?=dsmoptfilename/FROMSQLSERVer==sqlserver
value [or cfg value]?=sqlservername/INSTANTRestore=YesNo/INTO=dbname/KEEPCDC/LOGFile=tdpsql.log [or
cfg value]?=logfilename/LOGPrune=60 [or cfg
value]?=numdays=No/OBJect=,objectname*/QUERYNode=DP=ALWAYSON/Quiet/RECOVery=Yes?=No/RELOCATEDir=dbfiledir[,logfiledir[dbfiledir,otherfiledir]]dbfiledir,filestream
files]]dbfiledir/RESTOREDAtecurrent date=date/RESTORETimecurrent
time=time/SQLAUTHentication=INTegrated [or cfg value]?=SQLuserid/SQLPassword="
"?=sqlpasswordname/SQLSERVer=[local computer name or cfg
value]?=sqlserver-connection/SQLUSer=sa?=sqlusername/VerifyOnly
TDPSQLCRestore,dbname*FULL/CONFIGfile=tdpsql.cfg?=configfilename/FCMOPTFile=dsm.opt?=dsmoptfilename/FROMSQLSERVer==sqlserver
value [or cfg value]?=sqlservername/INSTANTRestore=YesNo/INTO=dbname/KEEPCDC/LOGFile=tdpsql.log [or
cfg value]?=logfilename/LOGPrune=60 [or cfg
value]?=numdays=No/OBJect=,objectname*/QUERYNode=DP=ALWAYSON/Quiet/RECOVery=Yes?=No/RELOCATEDir=dbfiledir[,logfiledir[dbfiledir,otherfiledir]]dbfiledir,filestream
files]]dbfiledir/RESTOREDAtecurrent date=date/RESTORETimecurrent
time=time/SQLAUTHentication=INTegrated [or cfg value]?=SQLuserid/SQLPassword="
"?=sqlpasswordname/SQLSERVer=[local computer name or cfg
value]?=sqlserver-connection/SQLUSer=sa?=sqlusername/VerifyOnly