August 9, 2006 at 12:05 pm
Hi,
I have been unable to run dbcc checkdb on a database. I keep getting the error:
Server: Msg 8946, Level 16, State 12, Line 2
Table error: Allocation page (1:622776) has invalid PFS_PAGE page header values. Type is 0. Check type, object ID and page ID on the page.
The only reference in the forums that I've seen basically says that its hosed and the only way to recover is a restore. However, that is not possible since the corrupt db was backed up. Any suggestions?
Thanks,
bz
August 10, 2006 at 11:46 am
1> This article from Tibor Karaszi may be helpfull to you.
http://www.karaszi.com/sqlserver/info_corrupt_suspect_db.asp
2> This i found from another resource (Thanks to Satya SKJ)
This causes 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.
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.
Run DBCC CHECKDB with REPAIR clause to overcome some of the errors.
Make sure you have latest SP for SQL server.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply