FIX: Metadata corruption occurs when you update index statistics with INCREMENTAL=ON in SQL Server 2014
Content provided by Microsoft
Applies to: Microsoft SQL Server 2014 DeveloperMicrosoft SQL Server 2014 DeveloperMicrosoft SQL Server 2014 EnterpriseMicrosoft SQL Server 2014 EnterpriseMicrosoft SQL Server 2014 StandardMicrosoft SQL Server 2014 StandardMore
Assume that you have a partitioned table in Microsoft SQL Server 2014. When you update index statistics with INCREMENTAL=ON, metadata corruption occurs. Additionally, you receive the following error:
Msg 211, Level 23, State 50, Line 1 Possible schema corruption. Run DBCC CHECKCATALOG.
Note If you use SQL Server 2014 RTM or SQL Server 2014 Cumulative Update 1 (CU1), you may receive the errors as described in the symptom section. Error 211 is generic metadata corruption, state 50 is specific to this problem that will occur only if you set INCREMENTAL=ON.
Applying the fix in CU2 or latest service pack will prevent any future occurrence of the error. However, applying the fix will not repair the metadata that is already in an inconsistent state. To correct the inconsistent state, contact Microsoft SQL Server customer support. The issue was first fixed in the following cumulative update of SQL Server.
Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server: