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