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.
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.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Artikelnummer: 4019715 – Letzte Überarbeitung: 21.04.2017 – Revision: 8