Monday, December 14, 2009

Tips to Resolve “Database 'DBNAME' consistency errors...” Error Message

DBCC CHECKDB command is used to check the physical and logical integrity of MS SQL database objects. It is a three-stage process that performs DBCC CHECKALLOC, DBCC CHECKTABLE and DBCC CHECKCATALOG operations on the specified database. The command also validates the service broker data, contents of every indexed view, and link-level between file system directories and table metadata. While DBCC CHECKDB command repairs your SQL Server database in most situations, it might fail to perform under numerous circumstances. In such cases, an ideal way to is to restore the data from an updated database backup. But if in case, there is no database backup available or backup falls short to restore the lost data, then you will need to use advanced MS SQL Repair software.

As a practical scenario, you encounter the below error message while attempting to mount your Employee database:

“Database 'Employee' consistency errors in sysobjects, sysindexes, syscolumns, or systypes prevent further CHECKNAME processing.”

Above error message makes the data stored in the database inaccessible.

Grounds for the Error:

Corruption of Employee database either due logical or physical reasons.


To access the Employee database records and comprehensively resolve database corruption, you will need to follow the below measures:

To surmount damages caused due to physical damage of the system component, you will need to switch to a new system component. This can also include reinstalling the operating system.
To overcome the damages caused due to logical corruption, you will need to run DBCC CHECKDB command.

While DBCC CHECKDB command provides complete repair in most situations, it fails to perform when it finds error in Stage 2 (while running DBCC CHECKTABLE). This means that your system tables have been corrupted and DBCC CHECKDB can not repair your database. In such situations, the only way to repair your database is by using advanced SQL Database Recovery software.

No comments:

Post a Comment