Restore syntax

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

Syntax

Read syntax diagramSkip visual syntax diagramTDPSQLCRestore ,dbname* FULL?FIle=,logicalfilename*AFULLBDIFFerentialCGroup=,groupname*DLog=,logobjectname*ESet=,setobjectname*F

The syntax diagrams of the backup object type options corresponding to the letters A, B, C, D, E, F are shown following the Optional Parameters below.

Restore optional parameters:

Read syntax diagramSkip visual syntax diagram/BACKUPDESTination=backupdestination [or cfg value]TSMLOCAL/BACKUPMETHod=backupmethod [or cfg value]LEGACYVSS/BUFFers=3 [or cfg value]?=numbuffers/BUFFERSIze=1024 [or cfg value]?=buffersizeinkb/CONFIGfile=tdpsql.cfg?=configfilename/DBOonly/FROMSQLSERVer==sqlserver value [or cfg. value]?=sqlservername/IncludeTSMVM=Yes/INSTANTRestore=YesNo/INTO=dbname/KEEPCDC/LOGFile=tdpsql.log [or cfg value]?=logfilename/LOGPrune=60 [or cfg value]?=numdays=No/OBJect=,objectname*/QUERYNode=DP=ALWAYSONBOTH/Quiet /RELocate=,logicalfilename /TO=,physicalfilename /RELOCATEDir=dbfiledir[,logfiledir[dbfiledir,otherfiledir]]dbfiledir /RESTOREDAtecurrent date=date/RESTORETimecurrent time=time/SQLAUTHentication=INTegrated [or cfg value]?=SQLuserid/SQLBUFFers=0 [or cfg value]?=numsqlbuffers/SQLBUFFERSIze=1024 [or cfg value]?=sqlbuffersizeinkb/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/VerifyOnly
A Restore File Options
Read syntax diagramSkip visual syntax diagram/REPlace
B Restore Full Options
Read syntax diagramSkip visual syntax diagramB1B2
B1 Restore Full Options 1
Read syntax diagramSkip visual syntax diagram/RECOVery=Yes?=No/KEEPCDC/STANDby=undofilename/REPlace
B2 Restore Full Options 2
Read syntax diagramSkip visual syntax diagram/FIles=,logicalfilename*/GRoups=,groupname*/PARTial/RECOVery=Yes?=No/KEEPCDC/REPlace
C Restore Diff Options
Read syntax diagramSkip visual syntax diagram/RECOVery=Yes?=No/KEEPCDC/STANDby=undofilename/REPlace
D Restore Group Options
Read syntax diagramSkip visual syntax diagram/FIles=,logicalfilename*/REPlace
E Restore Log Options
Read syntax diagramSkip visual syntax diagram/RECOVery=Yes?=No/KEEPCDC/STANDby=undofilename/STOPAT=datetime/STOPATMark=markname/AFTER=datetime/STOPBEFOREMark=markname/AFTER=datetime
F Restore Set Options
Read syntax diagramSkip visual syntax diagram/FIles=,logicalfilename*/GRoups=,groupname*/REPlace