| The DBCC CHECKDB utility is a useful tool in MS SQL | | | | most of these errors appear due to hardware |
| Server databases that enables you to find and repair | | | | malfunctioning. For this, you can perform the following |
| any kind of issues in the MDF files. There are several | | | | tasks: |
| kinds of repair clauses that help in repairing different | | | | ◦ Analyzing the error logs to check if the error has |
| types of problems. However, at times, some of the | | | | occurred due to hardware parts corruption. |
| problems are so rigid that DBCC CHECKDB is unable | | | | ◦ Running hardware diagnostics and address the |
| to repair them. In such cases, you should opt for other | | | | errors that appear. |
| MDF file recovery techniques failing which you are | | | | ◦ Swapping the hardware components to isolate on |
| advised to use a third-party SQL recovery software | | | | the exact cause of error. |
| to recover MDF file. | | | | ◦ Formatting the hard disks and reinstalling the |
| Let us assume a situation in which you are running | | | | operating system |
| DBCC CHECKDB in an MS SQL Server 2000 | | | | • Check the database backup and use it: If the |
| database and getting the following error message: | | | | hardware parts are absolutely fine, then you should |
| “Table error: Object ID O_ID1, index ID I_ID1 | | | | restore the database from the backup provided it is |
| cross-object chain linkage. Page P_ID1 points to P_ID2 | | | | updated and clean. |
| in object ID O_ID2, index ID I_ID2.” | | | | • Run DBCC CHECKDB again: You should run |
| Cause: | | | | DBCC CHECKDB again with the suggested repair |
| The primary cause of this problem is that the P_ID1 | | | | clause to repair the damaged SQL database. |
| page is referring to the P_ID2 page in a different page. | | | | If the problem appears again even after using the |
| Resolution: | | | | aforementioned methods, then this is an obvious case |
| To overcome this erroneous situation, the following | | | | of using a third-party SQL data recovery software. |
| resolutions can be used, preferably in the given order: | | | | Having a rich user interface and the use of highly |
| • Resolve the hardware related errors: You should, | | | | advanced scanning mechanisms ensure that the .MDF |
| first of all, look for the hardware related errors as | | | | recovery is safe and secure. |