FIX: DBCC CHECKALLOC May Inaccurately Report Errors 8968 and 8998

Article translations Article translations
Article ID: 264041 - View products that this article applies to.
This article was previously published under Q264041
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 57286(SQLBUG_70)
Expand all | Collapse all

Symptoms

Running DBCC CHECKALLOC, CHECKDB, or DBREINDEX may incorrectly report error messages 8968 and 8998.

Cause

If any data file in the database has a size that is evenly divisible by 511232, the number of pages in a Global Allocation Map (GAM) interval, these error messages occur. The errors alone do not indicate any real problem with the database but might lead the user to believe a problem exists.

Workaround

Make sure that these are the only error messages reported by DBCC CHECKALLOC and DBCC CHECKDB. Also, make sure that the GAM page reported as "out of range" in the 8968 error message is evenly divisible by 511232. If both of these conditions are true, then increasing the size of the database file, by using an ALTER DATABASE statement, resolves the problem. Make sure that the auto shrink option is not set to on for this database, which might undo the effects of the ALTER DATABASE.

Status

Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack 3 for Microsoft SQL Server 7.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
274799 INF: How to Obtain Service Pack 3 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0
For more information, contact your primary support provider.

More information

If you are encountering this bug, database backups scheduled through the Database Maintenance Wizard may not complete because the database fails the consistency check. After the database file size increases, the backups should complete normally.

Properties

Article ID: 264041 - Last Review: November 2, 2013 - Revision: 3.0
Applies to
  • Microsoft SQL Server 7.0 Standard Edition
Keywords: 
kbnosurvey kbarchive kbbug kbfix KB264041

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com