Back in September I blogged about an old 2005 bug that prevented DBCC CHECKFILEGROUP checking the partitions of an object on the specified filegroup unless *all* partitions of the object are on the specified filegroup (not a smart way to set things up!). The bug was fixed ages ago in 2005 but has only just been fixed in 2008. The post which explains the bug in more detail is DBCC CHECKFILEGROUP bug on SQL Server 2008. This is an important feature to be able to split the consistency checks of a partitioned VLDB over a series of days – see CHECKDB From Every Angle: Consistency Checking Options for a VLDB for more details.
SQL Server 2008 SP1 Cumulative Update 6 (which you can get here) has the bug fix for 2008 finally. The KB article which describes the bug is 975991.
You’re all running regular consistency checks, right?
One thought on “DBCC CHECKFILEGROUP bug fixed in 2008 SP1 CU6”
I think the feature is fundamentally flawed in SQL2008 and SQL2008R2. I base this opinion on BOL and local testing. BOL for SQL 2012 reads the same so I assume the same behavior.
https://msdn.microsoft.com/en-us/library/ms187332(v=sql.105).aspx