Hi Del

Sorry for the confusion .... Thank you very much for the explanation , more
comprehensible .

A more small question did I can run it on same batch , did the process will
run the full and only after the log (full with recovery=no and log with
recovery=yes (default))
Or I need to add a sleep parameter ?????

Regards Robert

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

Robert,

No. This is not correct.
You still need to restore the log backup after you
restore the full backup. The point of my response was
to tell you that if you want to restore additional
log backups to the database, all of the restores
except for the last one need to be run with the
/RECOVERY=NO parameter. The last restore operation
should be run with the /RECOVERY=YES parameter
(which is the default).

Take a look at the "RECOVERY" option in the
User's Guide. It explains this for you.

Thanks,

Del

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

Del Hoobler
IBM Corporation
hoobler AT us.ibm DOT com

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 03/23/2004
01:20:28 AM:

> 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