FIX: LSN truncation occurs in AlwaysOn AG when disabling the change data capture feature in SQL Server 2016

Applies to: SQL Server 2016SQL Server 2016 DeveloperSQL Server 2016 Enterprise

Symptoms


Assume that you use AlwaysOn Availability Groups (AG) in Microsoft SQL Server 2016. When you try to disable the change data capture feature of the database in the AG, the Log Sequence Number (LSN) truncation of the database in every replica of this AG will be held by the m_replLSN field.

Resolution


Service pack information for SQL Server 2016

This update is fixed in the following service pack for SQL Server:

       Service Pack 2 for SQL Server 2016

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References


Learn about the terminology that Microsoft uses to describe software updates.