Restore with TSM on a specific date?

• Dominique DUCHEMIN

  SSChasing Mays

  Points: 604

  More actions

  February 3, 2013 at 12:46 pm

  #288790

  Hello,

  I am trying to retore a database from the 01-29-2013:

  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>

  Why does the line got truncated after the pitdate?

  I tried also with -pitdate same result...

  Any idea?

  Thanks,

  Dom

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  February 3, 2013 at 5:21 pm

  #1583766

  Not sure what /pit is, but shouldn't the date be in quotes, like this: "2013-01-29"?

  You may need to check your Tivoli documentation to be sure of the switches you need.