Note that if you have multiple instances per machine and want to restore
to one other than the default, you will need to also modify the
tdpsql.cfg (update the SQLSERVER parm to server\instance).

These type of complications, as well as several occasions where the
dsm.opt and tdpsql.cfg did not get changed back correctly, led me to
create a "generic" nodename that all the TDP backups go to, and a
front-end script to pick the SQL instance you want to land on when
firing up the gui.  That way, all the backups are readily available to
see and restore from on any SQL Server at all times.  It's a little more
work getting it set up, but saves time when you really need id - during
restores.

Steve Schaub
Systems Engineer, WNI
BlueCross BlueShield of Tennessee
423-752-6574 (desk)
423-785-7347 (cell)
***public***
 

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Del Hoobler
Sent: Tuesday, August 15, 2006 9:09 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] Restoring TDP for SQL backup onto another server

Paul,

Yes. There is an IBM Technote on the exact subject.

Go to:
        http://www.ibm.com/us/
Search for (include the double quotes):
        "Restoring an SQL database to an alternate database"

Our go to it directly here:
        http://www.ibm.com/Search/?q=1105967

Thanks,

Del

----------------------------------------------------


"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 08/15/2006
04:47:26 AM:

> Hi all,
>
> I have a Windows SQL server which has a large database on it which is 
> being backed up via TDP for SQL (version 5.3).
>
> Unfortunately the database is too large to restore back onto a 
> different location on the same server so I have to restore it onto
another server.
>
> I have another Windows SQL server on which I have installed TSM and 
> TDP for SQL.
>
> I am having a lot of problems trying to work out how to restore this 
> database onto the other server using the tdpsqlc restore command. Is 
> there an FAQ or cheat sheet that deals with this subject?
>
> Regards
> Paul
Please see the following link for the BlueCross BlueShield of Tennessee E-mail
disclaimer:  http://www.bcbst.com/email_disclaimer.shtm