Are you facing problems while working on a particular MS SQL Server 2000 database? If yes, then you should see if the same problem is reproducing on other databases as well. If not, then there are very strong chances that the database is corrupt. It could have become corrupt owing to miscellaneous reasons such as virus infections, malfunctioning of the hardware components, abrupt system shutdown while the database is open, etc. In such cases, you should fix the error by repairing SQL database failing which you should use a third-party SQL repair software.
Let us take a case in which you are getting the following error while working on the MS SQL Server 2000 database:
“Table error: Cross object linkage: Parent page P_ID1, slot S_ID1 in object ID O_ID1, index ID I_ID1, and page P_ID2, slot S_ID2 in object ID O_ID2, index ID I_ID2, next refer to page P_ID3 but are not in the same object.”
The problem in this case is due to the corruption in the page definitions in the SQL database.
The next page pointers of P_ID1 and P_ID2 pages are pointing each other in an incorrect manner leading to the error.
To address this problem, you would need to repair MDF file. To do this, you shold perform the follwoing methods preferably in the given order:
Fix hardware related issues: As is seen in many instances, such errors occur due to hardware malfunctioning. This can be addressed using the following measures:
Run the hardware diagnostics and try to repair the errors that you
Check the Windows Application log and MS SQL Server Error log to see whether the error has occurred because of any hardware-related problem.
Swap the hardware components to check and find out the exact reason for corruption.
If nothing else works out, then you can reinstall the operating system after formatting the hard disks.
Restore from backup: If the issues is not hardware-related, then you should restore the database from its clean and updated backup.
Run DBCC CHECKDB: In the end, you can choose to repair SQL database using the DBCC CHECKDB command using the appropriate repair clause.
If the problem is persisting, then you should repair the damaged SQL database using a third-party MDF file repair software. These read-only tools are able to repair and restore SQL components without inflicting any damages to the original database file.
The .MDF repair software that is recommended by most of the database recovery experts is Stellar Phoenix SQL Data Recovery. Able to recover SQL databases created in MS SQL Server 7.0, 2000, 2005, and 2008, this MS SQL repair software restores tables, NDF files, stored procedures, triggers, etc. In addition, this software is compatible with Windows 7, Server 2008, Vista, Server 2003, XP, and 2000.
My name is Mark Willium, I have done Ph.D in computer science and currently doing research on how to recover and repair corrupted SQL database. You can have more information about about SQL recovery software by visiting my blog http://solution-mdf-file-corruption.blogspot.com/