Tuesday, August 24, 2010

Memory allocation issues in MS SQL Server 2000 database results in Error 8902

In MS SQL Server, the system errors related with memory allocation often prove to be fatal for the database. Such problems can be caused by several reasons such as database corruption, which, in turn, can be the outcome of various other reasons. These reasons include virus infections, abrupt or unplanned system shutdown especially when the database is open, database header corruption, etc. You should try to find out the exact reason for such behavior and try to address the situation. If nothing works out, then I would suggest you to use a third-party MDF recovery software to recover SQL database.

Let us take a look at one of the system error that appears while you are working on an MS SQL Server 2000 database:

"Memory allocation error during DBCC processing."


Such memory allocation error occurs when there is no memory for the non-clustered index coverage checks.


Such system errors relating to memory allocation should be dealt by performing the following MDF recovery methods. Please note that you should perform these methods only in the given order:

Recovering the hardware corruption problems
Restoring from database backup
Running DBCC CHECKDB utility

For more resolution details visit this link: http://www.americanchronicle.com/articles/view/177453

No comments:

Post a Comment