This is my problem
I do a full Database BackUp with INIT at 01h30
Then I do a Full Transation Log with INIT at 7h00
Then each hour between 8h00 to 22h00 I do a Full Transaction Log with NO_INIT
When i ask to recover one of my Bakcup between 7h00 to 22h00
I got this message:
The log in this backup set begins at LSN 127000000005700001, which is ...
What's the problem (I use a SQLServer 2000)You need to apply all the log backups, in sequence, sine the latest database
backup:
RESTORE DATABASE... WITH NORECOVERY
RESTORE LOG ... WITH NORECOVERY
RESTORE LOG ... WITH NORECOVERY
...
RESTORE LOG ... WITH RECOVERY
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Guy Tanguay" <guy_tanguay@.hotmail.com> wrote in message
news:3b53412a.0402061042.cdfe4b1@.posting.google.com...
> This is my problem
> I do a full Database BackUp with INIT at 01h30
> Then I do a Full Transation Log with INIT at 7h00
> Then each hour between 8h00 to 22h00 I do a Full Transaction Log with
NO_INIT
> When i ask to recover one of my Bakcup between 7h00 to 22h00
> I got this message:
> The log in this backup set begins at LSN 127000000005700001, which is ...
> What's the problem (I use a SQLServer 2000)
No comments:
Post a Comment