Re: TDP for MS SQL - Restore DB
2004-03-26 01:25:09
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:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Del Hoobler
Sent: 24 March 2004 15:33
To: ADSM-L AT VM.MARIST DOT EDU
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" <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
|
|
|