The syntax error is that command does not have the backup type that you want to restore. For example,
TDPSQLC RESTORE WSS_Team_Content FULL or TDPSQLC RESTORE WSS_Team_Content LOG Keep in mind that the "/STOPAT=" optional parameter is only valid with "LOG" type restores. The book gives this example: tdpsqlc restore Test1 log=* /stopat="07/01/2010 13:56:00" Thanks, Del ---------------------------------------------------- "ADSM: Dist Stor Manager" <[email protected]> wrote on 02/03/2013 03:08:17 PM: > From: felymich <[email protected]> > To: [email protected], > Date: 02/03/2013 03:09 PM > Subject: Restoring for a specific date? > Sent by: "ADSM: Dist Stor Manager" <[email protected]> > > Hello, > > Thanks for the answer. > 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 / > Stopat=01/30/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. > > ACO0103E Invalid option for the specified command: RESTORE > WSS_Team_Content /REL > OCATE=WSS_Team_Content /to=E:\Program Files\Microsoft SQL Server > \MSSQL10.MSSQLSE > RVER\MSSQL\DATA\WSS_Team_Content.mdf /RELOCATE=WSS_Team_Content_Log > /to=E:\Progr > am Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA > \WSS_Team_Content_lo > g.ldf /FROMSQLServer=MBSQLSPCL-ENT /TSMOPTFile=dsm_MBSQLSPCL.opt /Stopat > > the truncation is still here and the command failed again... > > Thanks, > Dom > > +---------------------------------------------------------------------- > |This was sent by [email protected] via Backup Central. > |Forward SPAM to [email protected]. > +---------------------------------------------------------------------- >
