You can create a table which contains indexes in Microsoft SQL Server 2000. When you run DBCC CHECKDB command against the SQL Server database which contains this table, you won’t receive any error message. On the other hand, when you run a query which references the table, an access infringement could occur.

Grounds of the trouble

This catastrophic problem takes place due to a number of reasons. The most common reason is that the statistics group of the database table has got damaged. However, the DBCC CHECKDB command doesn’t detect the statistics group corruption.

In such situations, when the SQL Server query optimizer loads the corrupted statistics group to consider the most proficient execution plan, the access violation takes place. Depending upon the reason of statistics group corruption, the access violation could be varying.

Following two are the common reasons of damaged statistics group:

  • The columns, on which the SQL Server database engine builds the statistics group, contains contaminated data
  • Hardware tribulations exist

Nevertheless the reason of statistics group corruption and access violation, the result would the data loss and it needs to be cured as quickly as possible.

Follow these steps to work around the issue:

  • Consider whether the access violation is caused by the damaged statistics group or not. To do this, run DBCC SHOW_STATISTICS command against all the indexes of the table.
  • If the violation occurs when you run the command, repair the statistics that cause the violation. To do so, run UPDATESTATISITICS command against the statistics group.

This method works in some of the corruption and you can overcome from the data loss problems using it. But under some situations, this method doesn’t work and you may fall in need of SQL recovery.

SQL recovery is the process of repairing and restoring damaged SQL Server files which could be carried out using MDF recovery software. MDF recovery software performs a thorough scan of the affected MDF file and restores it intact.

Stellar Phoenix SQL Recovery software is the most advanced and the familiar SQL repair software which is capable of solving all of the SQL Server database corruption issues. The SQL recovery using this software could be performed for all the SQL server objects such as tables, reports, forms, macros, stored procedures, triggers, defaults and so forth.