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:[EMAIL PROTECTED] On Behalf Of Del Hoobler Sent: Tuesday, March 23, 2004 2:58 PM To: [EMAIL PROTECTED] 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 [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]
