• DBA

    Log shipping LSN mismatch issue The log in this backup set begins at LSN , which is too recent to apply to the database

    How to troubleshoot LSN mismatch issue in log shipping I have got an email, how to fix for log shipping, I already have a post for alwayson https://www.sqlserverblogforum.com/alwayson/how-to-solve-the-lsn-mismatch-in-sql-server/ For log shipping: you will have entry like this in the job error Message 2019-12-21 21:09:45.39 *** Error: The file ‘\LAPTOP-ISGUKEUC\Backup_Copy\T_20191221153913.trn’ is too recent to apply to the secondary database ‘T’.(Microsoft.SqlServer.Management.LogShipping) *** 2019-12-21 21:09:45.39 *** Error:   The log in this backup set begins at LSN 31000000048600001, which is too recent to apply to the database. An earlier log backup that includes LSN 31000000048200001 can be restored. RESTORE LOG is terminating abnormally.(.Net SqlClient Data Provider) *** Following is the code to find…