tdpsqlc RESTORE Problem

[emre]

hi ı want to restore sql with /restoredate and /restoretime parameter.My version is 7.1.2.1.

ACO0104E Invalid option: restore dbname /RECOVery=Yes /RESTOREDAte
=30.07.2015

how can achieve this problem?

TDPSQLC Restore *|dbname[,dbname,...] [Full]
[/BACKUPDESTination=TSM]
[/BACKUPMETHod=LEGACY|VSS|VMVSS] default: LEGACY
[/BUFFers=numbuffers] default: 3 (or cfg value)
[/BUFFERSIze=buffersizeinkb] default: 1024 (or cfg value)
[/CONFIGfile=configfilename] default: tdpsql.cfg
[/DBOonly]
[/FIles=*|logicalname[,logicalname,...] ]
[/FROMSQLserver=sqlservername] default: sqlserver value (or cfg value)
[/GRoups=*|groupname[,groupname,...] ]
[/INTO=dbname]
[/LOGFile=logfilename] default: tdpsql.log (or cfg value)
[/LOGPrune=numdays|No] default: 60 (or cfg value)
[/MOUNTWait=Yes|No] default: Yes (or cfg value)
[/OBJect=*|objectname[,objectname,...] ]
[/PARTial]
[/Quiet]
[/RECOVery=Yes|No] default: Yes
[/RELocate=lname /TO=pname [/RELocate=lname /TO=pname ...] ]
[/RELOCATEDir=directory[,logfiledirectory[,otherfiledirectory]] ]
[/REPlace]
[/RESTOREDAte=date]
[/RESTORETIme=time]
[/SQLAUTHentication=INTegrated|SQLuserid] default: INTegrated (or cfg value)
[/SQLBUFFers=numsqlbuffers] default: 0 (or cfg value)
[/SQLBUFFERSIze=sqlbuffersizeinkb] default: 1024 (or cfg value)
[/SQLPassword=sqlpasswordname] default: " "
[/SQLSERVer=[sqlprotocol:]sqlservername]
default: local computer name (or cfg value)
default sqlprotocol: "" (or cfg value)
[/SQLUSer=sqlusername] default: sa
[/STANDby=undofilename]
[/STRIPes=numstripes] default: 1 (or cfg value)
[/TSMNODe=tsmnodename] default: dsm.opt value
[/TSMOPTFile=dsmoptfilename] default: dsm.opt
[/TSMPassword=tsmpassword] default: dsm.opt value
[/VerifyOnly]

 

[moon-buddy]

Did you specify the right DB name and use the right date format? I don't think 30.07.2015 is correct.

 

[emre]

yes i did. you can set this parameters.For example my date format is 4.But ı cant restore with /restoredate and /restoretime parameter.
TDPSQLC Set PARMname=value
[/CONFIGfile=configfilename] default: tdpsql.cfg

where PARMname and possible values are:
BACKUPDESTination=TSM
BACKUPMETHod=[LEGACY|VSS|VMVSS]
BUFFers=numbuffers (2..8)
BUFFERSIze=buffersize (64..8192)
Press enter for more information or Q to quit.
DATEformat=dateformatnum
1 MM/DD/YYYY
2 DD-MM-YYYY
3 YYYY-MM-DD
4 DD.MM.YYYY
5 YYYY.MM.DD
DIFFESTimate=numpercent (1..99)
FROMSQLserver=sqlservername
IMPORTVSSSNAPSHOTSONLYWhenneeded=No (Yes|No)
ALWAYSONNode=nodename default: Windows Cluster Name
USEALWAYSONnode=No (Yes|No)
VEBACKUPNode=nodename
LANGUAGE=3-letter country code
ENU American English
PTB Brazilian Portuguese
CHS Chinese, Simplified
CHT Chinese, Traditional
FRA Standard French
DEU Standard German
ITA Standard Italian
JPN Japanese
KOR Korean
ESP Standard Spanish
Press enter for more information or Q to quit.
LOCALDSMAgentnode=nodename
LOGFile=logfilename
LOGPrune=[numdays|No] (0..9999) | No
MOUNTWaitfordata=[Yes|No]
NUMBERformat=numberformatnum
1 n,nnn.dd
2 n,nnn,dd
3 n nnn,dd
4 n nnn.dd
5 n.nnn,dd
6 n'nnn,dd
SQLAUTHentication=[INTegrated|SQLuserid]
SQLBUFFers=numsqlbuffers (0..999)
SQLBUFFERSIze=sqlbuffersize (64..4096)
SQLSERVer=[sqlprotocol:]sqlservername
STRIPes=numstripes (1..64)
TIMEformat=timeformatnum
1 HH:MM:SS
2 HH,MM,SS
3 HH.MM.SS
4 HH:MM:SSA/P