[SQL]HotFix KB2969896 - a dangerous data loss bug in SQL Server 2012 and 2014



The online index rebuild can cause index corruption or data loss when it is used together with concurrent queries that modify many rows in Microsoft SQL Server 2012 Service Pack 1 or Microsoft SQL Server 2014. 

This issue occurs when the following conditions are true:
  • The online index build query runs in parallel mode.
  • Deadlock error and a fatal error such as "lock timeout" occur in a specific order

FIX: KB2969896

Or you can go to this website, a SQL professional explain and help you how to fix it


Newer Older