Hi Del

If I understand correctly to restore a full database + a supplement log of a
specific database object my command will be:

 tdpsqlc restore Campus full /fromsqlserver=highlearn /tsmnode=highlearnk
/tsmpassword=xxxxxx /recovery=no

It will restore the full backup and will add automatically the log ......

Thank you for your response ...

Regards Robert

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Del
Hoobler
Sent: Monday, March 22, 2004 7:55 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: TDP SQL question

Robert,

You will need to add the "/RECOVery=No" option
to the restore of the full. If your physical environment
on the target system does not match the original system,
you may also have to use the "/RELOCATE=" and "/TO=" options.

Thanks,

Del

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

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 03/22/2004
05:35:35 AM:

> Hi to all
>
> I created a batch file to restore a database object and my question if
is a
> way to run it in one command the full and log for this database object.
>
> Here my command line for full and log  restore :
>
> Full:    tdpsqlc restore Campus full /fromsqlserver=highlearn
> /tsmnode=highlearnk /tsmpassword=xxxxxx
> log:     tdpsqlc restore Campus log /fromsqlserver=highlearn
> /tsmnode=highlearnk /tsmpassword=xxxxxx
>
> My TDP for Ms SQL version  is 5.1.5.0
>
> T.I.A Regards
> Robert Ouzen
> E-mail: rouzen AT univ.haifa.ac DOT il