SQL 2008 sp2 64-bit DBCC CheckDB PFS Error

Question

SQL 2008 sp2 64-bit DBCC CheckDB PFS Error

cheetah2399

Mr or Mrs. 500

Points: 567
More actions
March 14, 2012 at 1:51 pm

#257946

DB was originally a 2k5 version, but was restored to 2k8 well over a year ago and changed to compatibility of 10 at that time. It has been running fine up until a few days ago. Our maintenance plan does not error on the checkdb, but SQLdumps are created.
Msg 8914, Level 16, State 1, Line 1
Incorrect PFS free space information for page (1:1895363) in object ID 1998630163, index ID 0, partition ID 72057594045071360, alloc unit ID 72057594049200128 (type In-row data). Expected value 80_PCT_FULL, actual value 100_PCT_FULL
Put the db in SUM and ran DBCC CHECKDB ('db', REPAIR_ALLOW_DATA_LOSS) Came back no errors reported.
Ran DBCC CHECKDB WITH all_errormsgs, no_infomsgs again, and the same error came up. Did the process again, no errors either time. Ran the checkdb one more time after coming out of SUM and the error was back.
I know that this is a benign error, but it's disconcerting that it comes back. Has anyone else come across this and found a resolution?
March 15, 2012 at 5:02 am

This was removed by the editor as SPAM

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

sam_mastermind SSCommitted Points: 1975 More actions · Answer 1

Hope this link will help you a lot : http://www.sqlskills.com/BLOGS/PAUL/post/CHECKDB-From-Every-Angle-Can-CHECKDB-repair-everything.aspx

Paul Randal One Orange Chip Points: 29544 More actions · Answer 2

Benign. See http://www.sqlskills.com/BLOGS/PAUL/post/Corruption-bug-that-people-are-hitting-Msg-8914-PFS-free-space.aspx

Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

Here are the two URLs from above so that they are hot links:

http://www.sqlskills.com/BLOGS/PAUL/post/CHECKDB-From-Every-Angle-Can-CHECKDB-repair-everything.aspx

http://www.sqlskills.com/BLOGS/PAUL/post/Corruption-bug-that-people-are-hitting-Msg-8914-PFS-free-space.aspx

cheetah2399 Mr or Mrs. 500 Points: 567 More actions · Answer 4

Thank you for the replies. Everything I have found on this says that this was fixed in 2008, however, we are having the problem, so apparently, it is still an issue.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

I asked Paul about that, he said as far as he knows it is an outstanding bug. It is benign though, only problem is that it's causing CheckDB to fail.

Can you backup/restore this DB to a dev/test server to play with?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

cheetah2399 Mr or Mrs. 500 Points: 567 More actions · Answer 6

cheetah2399

Mr or Mrs. 500

Points: 567

March 16, 2012 at 6:37 am

#1460453

Going to try that today.