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
