Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pramod21
Yak Posting Veteran
64 Posts |
 Posted - 2012-09-12 : 05:16:09
|
| HI,i have schedule database backup full backup on daily basis and log backup on hourly basis.after 3 hour in between i took a differential back up and restore it successfully. after restoring differential backup i tried to restore transaction log back up but it shows me an error.. that : "System.Data.SqlClient.SqlError: The log in this backup set terminates at LSN 30000000010700001, which is too early to apply to the database. A more recent log backup that includes LSN 30000000013400001 can be restored. (Microsoft.SqlServer.Smo)"can u plz let me know that how i will restore transaction back up after restoring Differential backup.thnx... |
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2012-09-12 : 05:32:18
|
| It clearly says that, you have to restore a previous log backup, before restoring the current log backup. Here the Lsn Sequence is mismatching.Check the msdb.backupset table for the LSN sequence and physical path of your log backup.Senthil Kumar C------------------------------------------------------MCITP - Database Administration SQL SERVER 2008MCTS - Database Development SQL SERVER 2008 |
 |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2012-09-12 : 13:37:57
|
quote:
Originally posted by senthil_nagore
It clearly says that, you have to restore a previous log backup, before restoring the current log backup. Here the Lsn Sequence is mismatching.Check the msdb.backupset table for the LSN sequence and physical path of your log backup.Senthil Kumar C------------------------------------------------------MCITP - Database Administration SQL SERVER 2008MCTS - Database Development SQL SERVER 2008
Actually, the message is stating that the transaction log backup being applied is too early.You cannot restore a transaction log backup that was taken before the differential that was applied. You can only restore log backups taken after the differential backup completed. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-09-12 : 15:48:12
|
| Pramod, do you have a transaction log backup from after the differential?Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
Restoring Transaction log backup