Re: Database restore question
From: Olivier (olivierwarez_at_netscape.net)
Date: 06/08/04
- Next message: Olivier: "Re: Do updates kick tables out of cache?"
- Previous message: Sandy Byrnes: "What users are logged in?"
- In reply to: Andre: "Database restore question"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 09 Jun 2004 00:43:19 +0200
Andre wrote:
> Hi,
>
>
>
> I have a database (or better: used to have) and backup consisting of
>
> - the initial (complete) database
>
> - all log files since then (or so I thought)
>
> After making a data entry error I wrote the log to the backup and
>
> tried a point of time restore.
>
> Unfortunately that failed with the message
>
>
>
> "The log in this backup set begins at LSN xxx, which is too late to apply to
> the database. An earlier log backup that includes LSN yyy can be restored."
>
.. You should pass *all* log files since last full backup. At what time
do you have this message ?
>
> and left the database in an inaccessible state.
>
The database is just read-only, you can get it back doing a RESTORE WITH
RECOVERY ( but you will not be able to apply more trans. log then )
- Next message: Olivier: "Re: Do updates kick tables out of cache?"
- Previous message: Sandy Byrnes: "What users are logged in?"
- In reply to: Andre: "Database restore question"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
