Re: POINT IN TIME RESTORE
From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 03/14/04
- Next message: Hari Prasad: "Re: Best performance"
- Previous message: Erland Sommarskog: "Re: Cursor inside another cursor, or...?"
- In reply to: Craig H.: "Re: POINT IN TIME RESTORE"
- Next in thread: Tim: "Re: POINT IN TIME RESTORE"
- Reply: Tim: "Re: POINT IN TIME RESTORE"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 14 Mar 2004 21:09:04 +0530
Hi,
To add on to craigs posting,
The POINT-IN-TIME recovery will work only if the database's Recovery moel is
set to "FULL" and the model is not
changed after theFULL database backup.
Steps:
1. Perform a transaction log backup of the original database (If you have
not performed one)
2. RESTORE DATABASE TEST1 FROM BBA (Give the correct backup file / device
name) WITH NORECOVERY
3. Restore the subsequent transaction log files in order of backup WITH
NORECOVERY option till the final transaction log file
4. In the the final transaction log restore mention WITH RECOVERY and
STOPAT='date and time'
Thanks
Hari
MCDBA
"Craig H." <spam@[at]thehurley.[dot]com> wrote in message
news:#T$bgUICEHA.2556@TK2MSFTNGP12.phx.gbl...
> Is there only 1 tlog created upto "8:30" and after?
>
> If there are multiple tlogs you'll have to issue something like...
>
> restore database dbname.bak from bba with norecovery
> restore log logname1.tlog from bba with norecovery
> restore log logname2.tlog from bba with recovery, stopat = '2004-03-07
8:30:00'
>
> Regards,
> Craig.
>
> Cris wrote:
>
> > When I try to restore a database with query analyser and point in time
restore, I always obtain this error message : The log in this backup set
terminates at LSN 69508000000440000001, which is too early to apply to the
database. A more recent log backup that includes LSN 69508000000440300001
can be restored.
> >
> > My request is : RESTORE DATABASE TEST1 FROM BBA with norecovery
> > RESTORE LOG TEST1 FROM BBA
> > WITH recovery, STOPAT = '2004-03-07 8:30:00'
> >
> > I have the same problem with all my databases and if I look in my device
BBA, I can see that I start with a full backup on 2004-03-07 and I continue
with logs backup until 2004-03-13.
> >
> > What's wrong ?
- Next message: Hari Prasad: "Re: Best performance"
- Previous message: Erland Sommarskog: "Re: Cursor inside another cursor, or...?"
- In reply to: Craig H.: "Re: POINT IN TIME RESTORE"
- Next in thread: Tim: "Re: POINT IN TIME RESTORE"
- Reply: Tim: "Re: POINT IN TIME RESTORE"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
