Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sagitariusmzi
Posting Yak Master
113 Posts |
 Posted - 2009-06-08 : 00:05:09
|
| Hi, I am getting the error when i execute DBCC CHECKDB"Incorrect PFS free space information for page (1:66909) in object ID 516196889, index ID 1, partition ID 72057594050183168, alloc unit ID 72057594056212480 (type LOB data). Expected value 0_PCT_FULL, actual value 100_PCT_FULL."How to correct this errorPlease reply immediate.Thanks |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-06-08 : 05:17:20
|
Is that the only error you get from CheckDB? Can you perhaps post the results of this query first?DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS Take a look at this article. [url]http://www.sqlservercentral.com/articles/65804/[/url]--Gail ShawSQL Server MVP |
 |
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2009-06-23 : 10:35:30
|
| Which version of SQL Server are you on? This is an expected error before 2005 and CHECKDB used to silently fix them up without telling you. From 2005 onwards, they're reported. If you're on the latest SP you shouldn't see them, before that the algorithm to keep track of free space for text/heap pages *still* had some holes in it - sigh.If that's the only error you get, it's benign. If you're seeing lots of them or you're on the latest SP, give PSS a call.Paul S. Randal,Managing Director, SQLskills.com Blog: www.SQLskills.com/blogs/paul Twitter: twitter.com/PaulRandalSQL MVP, Microsoft RD, Contributing Editor of TechNet MagazineAuthor of SQL 2005 DBCC CHECKDB/repair code |
|
|
|
sagitariusmzi
Posting Yak Master
113 Posts |
Posted - 2009-07-10 : 01:54:37
|
| I am using Sql Server 2005, |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-07-10 : 02:50:30
|
| What service pack?Is this the only error that checkDB returns?--Gail ShawSQL Server MVP |
|
|
|
|
|
|
|
|
Incorrect PFS free space information for page (1:6