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

2014-07-05

Important!!

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

SQLPerformance.com

Newer Older