FIX: Metadata corruption occurs when you update index statistics with INCREMENTAL=ON in SQL Server 2014

Symptoms
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.
Resolution
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.

Cumulative Update 2 for SQL Server 2014

About cumulative updates for 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:
Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Propiedades

Id. de artículo: 2970386 - Última revisión: 07/29/2015 07:48:00 - Revisión: 2.0

Microsoft SQL Server 2014 Developer, Microsoft SQL Server 2014 Enterprise, Microsoft SQL Server 2014 Standard

  • kbqfe kbfix kbsurveynew kbexpertiseadvanced KB2970386
Comentarios
with INCREMENTAL=ON" in SQL Server 2014 partitioned table." />
with INCREMENTAL=ON" in SQL Server 2014 partitioned table." />