Transaction log backups and restores 
Author Message
 Transaction log backups and restores
We had a problem restoring from a trasnaction log backup because of the
following error "The log in this backup set begins at LSN
94323000000001600002, which is too late to apply to the database. An earlier
log backup that includes LSN 94278000000005400001 can be restored".   We did
the full restore with only replace option then the following 6 or so
transaction  restores worked fine yet got to one and no good yet backups
worked fine and positive we are doing in correct order.  Any ideas?  Thanks
Joe


Thu, 02 Dec 2004 02:32:23 GMT
 Transaction log backups and restores

Only 2 things I am aware of...
1. you are doing the restores in the wrong order or
2. recovery is running ( use norecovery)..

otherwise, corruption and call MS.

--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), C{*filter*}te, NC
www.computeredservices.com
(Please respond only to the newsgroups.)

I support the Professional Association of SQL Server (PASS) and it community
of SQL Server professionals.
www.sqlpass.org


Quote:
> We had a problem restoring from a trasnaction log backup because of the
> following error "The log in this backup set begins at LSN
> 94323000000001600002, which is too late to apply to the database. An
earlier
> log backup that includes LSN 94278000000005400001 can be restored".   We
did
> the full restore with only replace option then the following 6 or so
> transaction  restores worked fine yet got to one and no good yet backups
> worked fine and positive we are doing in correct order.  Any ideas?
Thanks
> Joe



Sat, 04 Dec 2004 16:02:40 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Restore from old backup and current transaction log

2. Restore Database from Backup without Transaction Log?

3. Restoring transaction log backup generates error 1511 (SQL 6.5)

4. restore database without backup of transaction log

5. Question about Transaction log (backup-restore)

6. Urgent : No backup available and want to restore from transaction log

7. Backup and Restore Transaction Log

8. Please help...Backup vs Transaction log vs Restore is so important

9. Please help...Backup vs Transaction log vs Restore is so important

10. Restoring contents of transaction log (not backup)

11. Non-Logged operations causing transaction log restore to fail

12. Log shipping: Auto restore transaction log?


 
Powered by phpBB® Forum Software