Get Rid of Error 8921 from MS SQL Server 2000 Database

The DBCC statements in MS SQL Server are used to check and fix logical and physical consistency. Different DBCC statements have different purposes.The CHECKTABLE command in MS SQL Server is used to check the integrity of database tables. In SQL Server 2000, it is used to make it more scalable and to achieve parallelism. But sometimes, you get error messages like:

"CHECKTABLE terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors."

This means that the internal query which is used by DBCC for parallelism and scalability failed for an unknown reason and the QP raised an error from the ExecSql call. The CHECKTABLE command uses different parameters to check different types of checks. But if the database table gets corrupt, it stops working and exits abruptly. Database corruption can take place because of a number of reasons like malfunctioning hardware, virus attack and other reasons.

Rectifying error 8921 in MS SQL Server 2000 database is very necessary. You can do this by using the following MDF repair methods.

  • Run hardware diagnostics and fix all errors. Check Microsoft Windows NT system, application log, SQL Server error log and check if the error 8921 was a result of hardware failure. If you cannot solve the problem, then it would be better if you switch to a new hardware system and reformat and reinstall the operating system.
  • Check the backup. You can restore the database from the backup.
  • If the error is still not fixed, then you should execute DBCC CHECKDB without a repair clause and find out the extent to which it is corrupt.

These methods would surely remove the error from your PC and enable you to access the database as before and ensure SQL MDF repair. But if it is not fixed, then you should use third party MDF repair software to repair SQL databases from all instances of corruption. These are compatible with all versions of SQL like SQL Server 2000, 2005, and 2008 and are able to repair all database objects like stored procedures, database constraints, queries, triggers, user defined data types, etc.