DBCC DBREINDEX Unable to Rebuild SQL Indexes!

MS SQL is the renowned and most widely used database. It uses indexes for better performance and efficiently manages the database. With the help of indexes, database manger can easily locate the specified table. In some situation, indexes gets corrupted due to fragmentation of data, which hampers the performance of database. In order to surmount the issue, reorganization of database is done on each index of all the tables. This can be done with the help of DBCC DBREINDEX which rebuild all the indexes in order to reduce fragmentation.

However, in some situation it fails to work and unable to reorganize the database. Rebuilding is blocked and database remains in unusable state. This phenomenon makes the database inaccessible and sometimes leads to severe data loss. In some circumstances, DBCC DBREINDEX causes access violation in CTableMetadata::LoadIndex function when it is used rebuild the table having hypothetical indexes. These indexes are created during tuning process and dropped when the index tuning wizard process ends.

Free Download

In addition when you run this utility on damaged database you also come across various error messages like as:

  • “Server: Msg 7995, Level 16, State 3, Line 1.
  • Database ‘test’ consistency errors in sysobjects, sysindexes, syscolumns, or systypes prevent further CHECK processing.”
  • The occurrence of above error message indicates the corruption of sysindexes table. So, if you run DBCC CHECKTABLE or DBCC DBREINDEX to these corrupted tables you will receive below error messages:
  • Server: Msg 2537, Level 16, State 40, Line 1
  • Table error: Object ID 2, index ID 0, page (1:3282), row 5. Record check (length <= colInfo.CbMaxLen () && pCol != NULL) failed. Values are 1120 and 1088.
  • Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 2, index ID 0, page (1:3282), row 6. Record check (length <= colInfo.CbMaxLen () && pCol != NULL) failed. Values are 1120 and 1088.

So, to resolve such error and to re-access your SQL database, you have to restore it by using valid backup. However, in case if you don’t have any backup facility you can use MS SQL Database Repair Software that not only repairs your corrupted database but also restore the database. It uses strong algorithm to recover corrupted databaseMS SQL is the renowned and most widely used database. It uses indexes for better performance and efficiently manages the database. With the help of indexes database manger can easily locate the specified table. In some situation indexes gets corrupted due to fragmentation of data. It also hampers the performance of database. In order to surmount the issue reorganization of database is done on each index of all the tables. This can be done with the help of DBCC DBREINDEX which rebuild all the indexes in order to reduce fragmentation. It is inbuilt tool of MS SQL server that performs an offline operation of rebuilding of indexes.

Free Download