Re: TDP for MS SQL - Restore DB
2004-03-24 08:33:45
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" <ADSM-L AT VM.MARIST DOT EDU> 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
|
|
|