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
