Restoring from a specific date?

[felymich]

Hello,
I am trying to restore a database from the 01/29/2013 but the command line failed:

C:\Program Files\Tivoli\TSM\TDPSql>TDPSQLC RESTORE WSS_Team_Content /RELOCATE=WS
S_Team_Content /to="E:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MS
SQL\DATA\WSS_Team_Content.mdf" /RELOCATE=WSS_Team_Content_Log /to="E:\Program Fi
les\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\WSS_Team_Content_log.ldf
" /FROMSQLServer=MBSQLSPCL-ENT /TSMOPTFile=dsm_MBSQLSPCL.opt -pitdate=01/29/2013

IBM Tivoli Storage Manager for Databases:
Data Protection for Microsoft SQL Server
Version 5, Release 5, Level 5.0
(C) Copyright IBM Corporation 1997, 2010. All rights reserved.
ACO0104E Invalid option: RESTORE WSS_Team_Content /RELOCATE=WSS_Team_Content /to
=E:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\WSS_Team_C
ontent.mdf /RELOCATE=WSS_Team_Content_Log /to=E:\Program Files\Microsoft SQL Ser
ver\MSSQL10.MSSQLSERVER\MSSQL\DATA\WSS_Team_Content_log.ldf /FROMSQLServer=MBSQL
SPCL-ENT /TSMOPTFile=dsm_MBSQLSPCL.opt -pitdate

C:\Program Files\Tivoli\TSM\TDPSql>


Any idea?
Thanks,
Dom

 

[felymich]

tries also with "/"
C:\Program Files\Tivoli\TSM\TDPSql>TDPSQLC RESTORE WSS_Team_Content /RELOCATE=WS
S_Team_Content /to="E:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MS
SQL\DATA\WSS_Team_Content.mdf" /RELOCATE=WSS_Team_Content_Log /to="E:\Program Fi
les\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\WSS_Team_Content_log.ldf
" /FROMSQLServer=MBSQLSPCL-ENT /TSMOPTFile=dsm_MBSQLSPCL.opt /pitdate=01/29/2013

IBM Tivoli Storage Manager for Databases:
Data Protection for Microsoft SQL Server
Version 5, Release 5, Level 5.0
(C) Copyright IBM Corporation 1997, 2010. All rights reserved.
ACO0104E Invalid option: RESTORE WSS_Team_Content /RELOCATE=WSS_Team_Content /to
=E:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\WSS_Team_C
ontent.mdf /RELOCATE=WSS_Team_Content_Log /to=E:\Program Files\Microsoft SQL Ser
ver\MSSQL10.MSSQLSERVER\MSSQL\DATA\WSS_Team_Content_log.ldf /FROMSQLServer=MBSQL
SPCL-ENT /TSMOPTFile=dsm_MBSQLSPCL.opt /pitdate

C:\Program Files\Tivoli\TSM\TDPSql>

same truncation...

 

[moon-buddy]

You have a syntax issue. Look at this link

 

[zsoltesz]

Hi,

As I know, there is no /pitdate option in the syntax of the tdpsqlc restore command.

Zoli