Del, I'm glad I saved this thread. I'm working on a similar case, and the standin DBA askes if this method will work "if we can restore to a SQL Server 2000 machine with the SQL 7 backup?"
---- Original message ---- >Date: Thu, 8 Mar 2007 09:12:02 -0500 >From: Del Hoobler <[EMAIL PROTECTED]> >Subject: Re: [ADSM-L] TSM SQL restore >To: [email protected] > >Hi Mark, > >Are you using the same TSM NODENAME in the DSM.OPT file that was >used to back up the databases? > >If not, try this: > >1. Copy the DSM.OPT file from the SERVER1 machine to the > SERVER2 machine. Call it something like, SERVER1.OPT > >2. Connect to the TSM Server from this machine, storing the password. > TDPSQLC QUERY TSM /TSMOPTFile=SERVER1.OPT /TSMPASS=password > >3. Make sure you can see the backups: > TDPSQLC QUERY TSM * /TSMOPTFile=SERVER1.OPT > >4. If everything above works, retry the restore. > TDPSQLC restore DBA_Admin full /RECOVery=No /fromsqlserver=SERVER1 >/TSMOPTFile=SERVER1.OPT > TDPSQLC restore DBA_Admin log=* /fromsqlserver=SERVER1 >/TSMOPTFile=SERVER1.OPT > >There is a IBM Technote that explains this for the DP/SQL GUI: > http://www-1.ibm.com/support/docview.wss?uid=swg21105967 > >Thanks, > >Del > >---------------------------------------------------- > >"ADSM: Dist Stor Manager" <[email protected]> wrote on 03/08/2007 >08:37:51 AM: > >> Very similar. I get this: >> >> D:\TDPSql>tdpsqlc restore DBA_Admin full /fromsqlserver=SDHQ04-DEVSQL04 >> IBM Tivoli Storage Manager for Databases: >> Data Protection for Microsoft SQL Server >> Version 5, Release 3, Level 3.0 >> (C) Copyright IBM Corporation 1997, 2006. All rights reserved. >> Starting Sql database restore... >> Querying Tivoli Storage Manager server for a list of database >> backups, please wait... >> ACO0261I There are no backups for the server named >SDHQ04-DEVSQL04\meta\0000. >> >> And I know there are backups there. >> Fred Johanson
