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