FIX: SQL Server 2016 does not log error messages that have a severity level of 21 for checksum mismatches found in In-Memory OLTP checkpoint files

Applies to: SQL Server 2016 Enterprise CoreSQL Server 2016 EnterpriseSQL Server 2016 Developer

Symptoms


Assume that you use In-Memory OLTP in Microsoft SQL Server 2016. You try to recover to the last successful checkpoint, for example during database startup.

If a checksum mismatch with the In-Memory OLTP checkpoint files is detected, the recovery operation fails. However, SQL Server does not log the corruption information that has a severity level of 21 in the error logs, as expected.

Resolution


This fix is included in Service Pack 1 for SQL Server 2016. If a checksum mismatch is detected during database recovery, error 3414 is written to the SQL Server error log and is assigned a severity level of 21.

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 Microsoft uses to describe software updates.