Yiannakis, That is correct. Please refer to the User's Guide for the exact syntax.
Thanks, Del ---------------------------------------------------- "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> wrote on 03/26/2004 01:29:12 AM: > Thanks Del. > So after my full restore I do a second restore with the "difffull" parameter > instead of "full" ? > Thanks > Yiannakis > > > > -----Original Message----- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of > Del Hoobler > Sent: 24 March 2004 15:33 > To: [EMAIL PROTECTED] > Subject: Re: TDP for MS SQL - Restore DB > > > Yiannakis, > > Saturday. > > If you want to restore it to a later point, > you will need to specify /RECOVERY=NO on the > restore of the full and then restore the last > differential backup with /RECOVERY=YES (default). > > Thanks, > > Del > > ---------------------------------------------------- > "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> wrote on 03/24/2004 > 02:33:02 AM: > > > Hi, > > I have the following schedules for a SQL dbase: > > Saturdays - full backup of dbase > > Weekdays - difffull backup of dbase > > > > I wanted to restore the dbase on Wednesday to another server, so I used > the > > command line as follows: > > > > tdpsqlc restore ChequeEnquiry full /relocate=ChequeEnquiryuiry_Data > > /to=H:\tsmrestore\cheqenq.mdf /relocate=ChequeEnquiryuiry_Log > > /to=H:\tsmrestore\cheqenq.lgf /fromsqlserver=IBCHQENQ > > -TSMPassword=xxxxx > > > > Have I restored the dbase as of last Saturday, or as of Tuesday ? > > Thanks > > Yiannakis
