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 |
|
learntsql
524 Posts |
 Posted - 2009-10-10 : 12:24:04
|
| Hi All,My BackUp strategy is as follows,-->Initial Full Backup-->Differential Backup-->Tran. Log Backup1-->Tran. Log Backup2When I am trying to Restore as follows its giving as error.-->Initiak Full Backup-->Tran. Log Backup2The Erro Message is:System.Data.SqlClient.SqlError: The log in this backup set begins at LSN 24000000036100001, which is too recent to apply to the database. An earlier log backup that includes LSN 24000000033400001 can be restored. (Microsoft.SqlServer.Smo). |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-10-10 : 15:07:16
|
| The error is saying that the transaction log that you're trying to restore is too recent, that there's an earlier one that needs to be restored first. You need to restore all the transaction logs, in order, since the full/diff backup that you restore.In this case you need to restore as follows:Initial Full backupTran log backup 1Tran log backup 2--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
Transactional log backup restore failure