Fix Index Data loss issue – SQL Server 2012
This is a hotfix from Microsoft for SQL Server 2012 to prevent the data loss while building cluster index.
Microsoft provided two options to solve this problem
1. Work around – run the online index build in serial mode (DOP = 1).
Categories: SQL Server