Discussing Error 7991 in SQL Server 2000 and guidelines to perform SQL recovery

MS SQL Server stores information related to various objects, data types, constraints, etc. in system base tables. This information is known as metadata. The system base tables usually exist in the master database. These tables are not visible by default. Only a person with administrative rights can access and modify them. Metadata corruption may occur due to various reasons, such as applications errors, power failures, hardware malfunction, etc. As a consequence, your valuable database files become inaccessible. To overcome this problem, you need to go for SQL server recovery software through a reliable third-party utility.

For instance, you may come across the following error while working with one of your MS SQL Server 2000 databases:

"System table mismatch: Table 'O_NAME' object ID O_ID has index id 1 in sysindexes but the status in sysobjects does not have the clustered bit set. The table will be checked as a heap"

Cause:

The above error occurred because of table metadata corruption. The index id '1' in 'sysindexes' corresponding to the table indicates that the specified table has a clustered index. However, this is not indicated in the sysobjects table.

This would make the SQL database and its valuable components inaccessible. To perform a complete restoration of all lost or deleted data, you may use a recent/updated backup. If the backup is missing, try to follow he resolution steps described below.

Resolution:

The below mentioned steps may help you resolve the issue:

• First, you need to check for any hardware related problem by closely examining the error logs. If a hardware malfunction occurred, you can try running hardware diagnostics or replacing the damaged hardware component.

• Run DBCC CHECKDB to resolve any logical corruption issues.

If the problem still persists, take help of a competent SQL database recovery software. These software carry out extensive scan of the corrupt database to effectively restore all MDF and NDF file components. They allow searching for MDF Files in any specific drive or volume in your system. You can also save all recovered queries, views, stored procedures etc. in a separate text file.

Stellar Phoenix SQL Recovery is a comprehensive tool that embraces rich set of advanced mechanisms to effectively repair corrupt SQL databases and retrieve all vital database objects, such as tables, views, indexes, queries, constraints, stored procedures, etc. The software displays preview of all database objects prior to recovery. Moreover, it is compatible with Windows 7, Server 2008, Vista, Server 2003, XP, and 2000.