Restore syntax

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

Syntax


1  TDPSQLC  Restore
2.1+ ,
2.1 dbname
2.1 *
1! FULL
1 
1  FIle=
2.1 + , logicalfilename
2.1 *
1 %A
1  FULL %B
1  DIFFerential %C
1  Group=
2.1 + , groupname
2.1 *
1 %D
1  Log=
2.1 + , logobjectname
2.1 *
1 %E
1  Set=
2.1 + , setobjectname
2.1 *
1 %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.

Figure 1. Restore optional parameters:

1?  /BACKUPDESTination=
2.1! backupdestination [or cfg value]
2.1 TSM
2.1 LOCAL?  /BACKUPMETHod=
2.1! backupmethod [or cfg value]
2.1 LEGACY
2.1 VSS?  /BUFFers
2.1! =3 [or cfg value]
2.1 
2.1 =numbuffers?  /BUFFERSIze
2.1! =1024 [or cfg value]
2.1 
2.1 =buffersizeinkb?  /CONFIGfile
2.1! =tdpsql.cfg
2.1 
2.1 =configfilename?  /DBOonly?  /FROMSQLSERVer=
2.1! =sqlserver value [or cfg. value]
2.1 
2.1 =sqlservername?  /IncludeTSMVM=
2.1! Yes?  /INSTANTRestore=
2.1! Yes
2.1 No?  /INTO= dbname?  /KEEPCDC?  /LOGFile
2.1! =tdpsql.log [or cfg value]
2.1 
2.1 =logfilename?  /LOGPrune
2.1! =60 [or cfg value]
2.1 
2.1 =numdays
2.1 =No?  /OBJect=
2.1 + , objectname
2.1 *?  /QUERYNode
2.1! =DP
2.1 =ALWAYSON
2.1 BOTH?  /Quiet   /RELocate= + , logicalfilename  /TO= + , physicalfilename   /RELOCATEDir=  dbfiledir [ + , logfiledir [! dbfiledir + , otherfiledir ] ]! dbfiledir?  /RESTOREDAte
2.1 =date
2.1! current date?  /RESTORETime
2.1 =time
2.1! current time?  /SQLAUTHentication
2.1! =INTegrated [or cfg value]
2.1 
2.1 =SQLuserid?  /SQLBUFFers
2.1! =0 [or cfg value]
2.1 
2.1 =numsqlbuffers?  /SQLBUFFERSIze
2.1! =1024 [or cfg value]
2.1 
2.1 =sqlbuffersizeinkb?  /SQLPassword
2.1! =" "
2.1 
2.1 =sqlpasswordname?  /SQLSERVer
2.1! =[local computer name or cfg value]
2.1 
2.1 =sqlserver-connection?  /SQLUSer
2.1! =sa
2.1 
2.1 =sqlusername?  /STRIPes
2.1! =1 [or cfg value]
2.1 
2.1 =numstripes?  /TSMNODe
2.1! =[dsm.opt value]
2.1 
2.1 =tsmnodename?  /TSMOPTFile
2.1! =dsm.opt
2.1 
2.1 =dsmoptfilename?  /TSMPassword
2.1! =[dsm.opt value]
2.1 
2.1 =tsmpasswordname?  /VerifyOnly
A Restore File Options

1+ 
1  /REPlace
B Restore Full Options

1 %B1
1 %B2
B1 Restore Full Options 1

1+ 
2.1  /RECOVery
2.2.1! =Yes
2.2.1 
2.2.1 =No
2.1?  /KEEPCDC
2.1  /STANDby= undofilename
1  /REPlace
B2 Restore Full Options 2

1+ 
1  /FIles=
2.1 + , logicalfilename
2.1 *
1  /GRoups=
2.1 + , groupname
2.1 *
1 /PARTial
1  /RECOVery
2.1! =Yes
2.1 
2.1 =No
1?  /KEEPCDC
1  /REPlace
C Restore Diff Options

1  /RECOVery
2.1! =Yes
2.1 
2.1 =No
1?  /KEEPCDC
1  /STANDby= undofilename
1  /REPlace
D Restore Group Options

1+ 
1  /FIles=
2.1 + , logicalfilename
2.1 *
1  /REPlace
E Restore Log Options

1+ 
2.1  /RECOVery
2.2.1! =Yes
2.2.1 
2.2.1 =No
2.1?  /KEEPCDC
2.1  /STANDby= undofilename
2.1  /STOPAT= datetime
2.1  /STOPATMark= markname?  /AFTER= datetime
2.1  /STOPBEFOREMark= markname?  /AFTER= datetime
F Restore Set Options

1+ 
1  /FIles=
2.1 + , logicalfilename
2.1 *
1  /GRoups=
2.1 + , groupname
2.1 *
1  /REPlace