Monday, December 21, 2009

How to Resolve “Database ID DB_ID, object 'OBJNAME' (ID O_ID)...”

The main purpose of DBCC CHECKDB command in MS SQL is to check the integrity (logical and physical) of all the specified database objects. The command performs three operations (DBCC CHECKALLOC, DBCC CHECKTABLE, and DBCC CHECKCATALOG) to comprehensively repair the corrupted database. While the repair command repairs your database in most situations, it might fail to repair in case of damage of critical system tables. In such circumstances, an easy way is to restore the data from an updated database backup. But in case of absence of an updated backup or the backup file itself getting corrupted, then you will need to search for advanced SQL Database Recovery application that can repair your database.

Consider a practical situation, where you receive the below error message when you attempt to mount your database:

“Database ID DB_ID, object 'OBJNAME' (ID O_ID). Loop in data chain detected at P_ID.”

After the above error message pops up, your database becomes unmountable. Furthermore, the data stored in your database becomes inaccessible.

Cause:

The root cause for the occurrence of the above error message is corruption in metadata structure of SQL database. Corruption can occur by both logical or physical reasons.

Resolution:

To resolve the above error message and to access the database records, follow the below three measures:

Swap the physically damaged system component with a new component.
Execute DBCC CHECKDB command (with appropriate repair clause.)
Restore the data from an updated database backup.

Out of the above three measures, the first measure provides complete resolution from the physical damage situations. The other two measures fail to perform in case the database is severely corrupted or there is no backup available. In such situations, the only alternative left is advanced SQL Repair software.

Such SQL Recovery tools ensure complete repair of most corrupted SQL databases. These applications come with interactive user documentation that makes the database user to easily understand the repair process. These repair tools are non destructive in nature.

No comments:

Post a Comment