ADSM-L

Re: TDP for MS SQL - Restore DB

2004-03-26 06:10:25
Subject: Re: TDP for MS SQL - Restore DB
From: Del Hoobler <hoobler AT US.IBM DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 26 Mar 2004 06:09:34 -0500
Yiannakis,

That is correct.  Please refer to the User's Guide
for the exact syntax.

Thanks,

Del

----------------------------------------------------

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> 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: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

<Prev in Thread] Current Thread [Next in Thread>