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 [EMAIL PROTECTED] "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED] On Behalf Of Del > Hoobler > Sent: Monday, March 22, 2004 7:55 PM > To: [EMAIL PROTECTED] > 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" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
