FIX: Database schema is corrupted when you restore a database from a snapshot in SQL Server

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


You restore a database from a database snapshot in SQL Server. When the database contains change tracking-enabled tables, the database schema becomes corrupted. Additionally, you receive the following error message:

Msg 211, Level 23, State 8

Corruption in database ID 28, object ID 41 possibly due to schema or catalog inconsistency. Run DBCC CHECKCATALOG.

Msg 3624, Level 20, State 1

A system assertion check has failed. Check the SQL Server error log for details. Typically, an assertion failure is caused by a software bug or data corruption. To check for database corruption, consider running DBCC CHECKDB. If you agreed to send dumps to Microsoft during setup, a mini dump will be sent to Microsoft. An update might be available from Microsoft in the latest Service Pack or in a Hotfix from Technical Support.


The fix for this problem is included in the following updates:


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


Learn about the terminology Microsoft uses to describe software updates.