SQL Server Error Msg 18842 – Failed to retrieve the oldest active log sequence number (LSN) from a commit record. Stop and restart SQL Server and the Log Reader Agent. If the problem persists, reinitialize all subscriptions to the publication.

In this blog post, let’s learn about the error message “18842 – Failed to retrieve the oldest active log sequence number (LSN) from a commit record. Stop and restart SQL Server and the Log Reader Agent. If the problem persists, reinitialize all subscriptions to the publication.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

18842 – Failed to retrieve the oldest active log sequence number (LSN) from a commit record. Stop and restart SQL Server and the Log Reader Agent. If the problem persists, reinitialize all subscriptions to the publication.

Reason for the Error

To be update soon…

Solution

To be update soon…