FIX: DBCC CHECKALLOC May Inaccurately Report Errors 8968 and 8998 (264041)
The information in this article applies to:
This article was previously published under Q264041
BUG #: 57286(SQLBUG_70)
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.
| Modification Type: | Major | Last Reviewed: | 3/14/2006 |
|---|
| Keywords: | kbBug kbfix KB264041 |
|---|
|