Fix error 8995 and repair MDF file in MS SQL Server 2000

Has your MS SQL Server 2000 edition started generating different types of error messages lately? If so, are these messages related to system tables? If so, then there is a serious case of database corruption that can lead to serious damage. You should try to find out the exact reason for corruption and try to root it out as soon as possible. If you are not repairing the SQL database then it is a good solution to use the services of third party SQL repair software.

Let’s look at a scenario where you get the following error message while working on an MS SQL Server 2000 database:

“System table ‘OBJNAME’ (object ID O_ID, index ID I_ID) is in file group FG_ID1. All system tables must be in file group FG_ID2.”

Cause: All system tables in MS SQL Server 2000 must be in the primary file group. This is also suggested in the error message.

Solution: This erroneous situation can be handled with the following methods in the order presented: Solving the Hardware Corruption Issues: There may be several hardware related corruption issues in the database that would be causing this problem.

To remove it, you can take the following measures:

Check the error logs and make sure that no error has occurred due to faulty hardware components. Run hardware diagnostics to verify that the hardware components are OK. If not, try to fix the errors.

Exchanging the hardware components to isolate the real reason for corruption.

If this problem occurs too often, check if you have enabled write caching on the hard drives. If so, contact the hardware manufacturer for the resolution.

Reinstall the operating system after formatting the hard drives.

Restore database backup: If you cannot find any errors in the hardware components, you should check the database backup. If it is up to date, restore the database from the backup.

Run DBCC CHECKDB: If the previous method doesn’t fix the problem, run the DBCC CHECKDB utility with the recommended repair clause.

There are instances when these methods don’t make the database normal. In such cases, you must use the services of a professional MDF file recovery software to recover the SQL database. Such tools exhibit notable features such as nondestructive database processing, interactive user interface, etc. for safe MS SQL repair.

Based on the similar lines of these discussed features, Stellar Phoenix SQL Data Recovery is one such tool that recovers the MDF file from all logical corruption cases. With recovery capability in MS SQL 7.0, 2000, 2005 and 2008, this MDF software repairs objects such as NDF files, default values, triggers, default settings, tables, stored procedures, etc. This MDF repair utility is compatible with Windows 7, Server 2008 , Vista, Server 2003, XP and 2000.

Source by Manya Gupta