During the process of Log shipping, the restore transaction log job fails and the ‘System.Data.SqlClient.SqlError: The log in this backup set begins at LSN, which is too recent to apply to the database. An earlier log backup that includes LSN can be restored.’ error is encountered, and whole process fails.
During the course of log shipping process, a new full backup of source database has been created. From this point on, ApexSQL Backup does not search for new full or differential backups to re-initialize destination database, but searches only for transaction log backups.
There are two workarounds for this issue:
b. The database recovery state needs to be changed to the no-recovery (restoring) state manually from SQL Server Management Studio. To perform this, the user needs to execute following steps:
Locate the destination database in SQL Server Management studio, Right click on the database, and navigate to Tasks ➜ Restore ➜ Database
In the Select a page menu, select Options and in the Recovery state drop menu select Restore with norecovery
Affected versions: ApexSQL Backup 2015.01.0011
© 2020 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 이용 약관 개인정보 보호정책