| Of late, has your MS SQL Server 2000 edition started | | | | If this problem happens rather too frequently, then |
| churning out various kinds of error messages? If yes, | | | | check if you have enabled write-caching on the hard |
| then are these messages related with system tables? | | | | disks. If yes, then contact the hardware manufacturer |
| If yes, then there is a serious case of database | | | | for the resolution. |
| corruption that may result in serious damages. You | | | | Reinstalling the operating system after formatting the |
| should try to find out the exact reason of corruption | | | | hard disks. |
| and look to eradicate that as soon as possible. If you | | | | Restoring from database backup: If you cannot find |
| fail to repair SQL database, then taking the services of | | | | any faults in the hardware components, then you |
| a third-party SQL repair software is a just solution. | | | | should check the backup of the database. If it is |
| Let us have a look at a scenario in which you are | | | | up-to-date, then restore the database from the |
| facing the following error message while working on | | | | backup. |
| an MS SQL Server 2000 database: | | | | Running DBCC CHECKDB: If the previous method |
| "System table 'OBJNAME' (object ID O_ID, index ID | | | | does not solve the problem, then run the DBCC |
| I_ID) is in filegroup FG_ID1. All system tables must be in | | | | CHECKDB tool with the recommended repair clause. |
| filegroup FG_ID2." | | | | There are instances when these methods do not bring |
| Cause: All the system tables in MS SQL Server 2000 | | | | the database to normalcy. In such cases, you need to |
| should be contained in the primary file group. This is | | | | take the services of a professional MDF file repair |
| suggested in the error message as well. | | | | software to repair SQL database. Such tools show |
| Resolution: This erroneous situation can be handled | | | | remarkable features such non-destructive handling of |
| using the following methods in the given order: Settling | | | | the database, interactive user interface, etc for safe |
| the hardware corruption issues: There could be | | | | and secure MS SQL repair. |
| several hardware-related corruption issues in the | | | | Based on the similar lines of these discussed features, |
| database that would be causing this problem. | | | | Stellar Phoenix SQL Data Recovery is one such tool |
| To remove these, you can perform the following | | | | that repairs MDF file from all instances of logical |
| measures: | | | | corruption. With repairing ability in MS SQL 7.0, 2000, |
| Checking the error logs and verify if any error has not | | | | 2005, and 2008, this.MDF repair software repairs |
| occurred due to defective hardware parts. Running | | | | objects such as NDF files, defaults, triggers, defaults, |
| hardware diagnostics to check whether the hardware | | | | tables, stored procedures, etc. This MDF repair utility is |
| components are fine. If not, then try to fix the errors. | | | | compatible with Windows 7, Server 2008, Vista, |
| Interchanging the hardware components to isolate the | | | | Server 2003, XP, and 2000. |
| actual reason for corruption. | | | | |