Re: [ADSM-L] TSM SQL restore

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 <hoobler AT US.IBM DOT COM>
>Subject: Re: [ADSM-L] TSM SQL restore
>To: ADSM-L AT VM.MARIST DOT EDU
>
>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" <ADSM-L AT VM.MARIST DOT EDU> 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