Sql-server – SQL Server: Invalid Log Scan Number (…) passed to log scan in database (…) is not valid

dbcc-checkdbsql serversql-server-2008-r2

We are getting a large number of the below errors on one of our production databases. CheckDB is completely clean.

We thought it was related to replication so we shut it down using sp_removedbreplication and the problem went away. For other reasons, we did a restore from last night backup which resurrected replication again. Immediately the errors returned and have persisted despite my removing replication again.

  • Error: 9003, Severity: 20, State: 1.
  • The log scan number (390576:5234:44) passed to log scan in database 'XXXX' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the
    problem results in a failure during startup.

I'm not finding much on the web related to this except articles for:

  1. The master database and SQL Server not starting
  2. Issues with replication

Any advice would be tremendously appreciated!

Best Answer

With the help of an outside source, the issue was nailed down to a corrupted transaction log and was fixed by reinitializing replication from scratch.

It was strongly recommended that we evaluate our I/O subsystems that house the log file to make sure there isn't a problem there which caused it.

Related Question