{"id":748,"date":"2010-01-25T10:47:00","date_gmt":"2010-01-25T10:47:00","guid":{"rendered":"\/blogs\/paul\/post\/DBCC-CHECKFILEGROUP-bug-fixed-in-2008-SP1-CU6.aspx"},"modified":"2017-11-16T13:01:31","modified_gmt":"2017-11-16T21:01:31","slug":"dbcc-checkfilegroup-bug-fixed-in-2008-sp1-cu6","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/paul\/dbcc-checkfilegroup-bug-fixed-in-2008-sp1-cu6\/","title":{"rendered":"DBCC CHECKFILEGROUP bug fixed in 2008 SP1 CU6"},"content":{"rendered":"<p>Back in September I blogged about an old 2005 bug that prevented <em>DBCC CHECKFILEGROUP<\/em> 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 <em><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/dbcc-checkfilegroup-bug-on-sql-server-2008\/\" target=\"_blank\" rel=\"noopener noreferrer\">DBCC CHECKFILEGROUP bug on SQL Server 2008<\/a><\/em>. This is an important feature to be able to split the consistency checks of a partitioned VLDB over a series of days &#8211; see <em><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/checkdb-from-every-angle-consistency-checking-options-for-a-vldb\/\" target=\"_blank\" rel=\"noopener noreferrer\">CHECKDB From Every Angle: Consistency Checking Options for a VLDB<\/a><\/em>\u00a0for more details.<\/p>\n<p>SQL Server 2008 SP1 Cumulative Update 6 (which you can get <a href=\"https:\/\/support.microsoft.com\/en-us\/help\/977443\/cumulative-update-package-6-for-sql-server-2008-service-pack-1\">here<\/a>) has the bug fix for 2008 finally. The KB article which describes the bug is <a href=\"https:\/\/support.microsoft.com\/en-us\/help\/975991\">975991<\/a>.<\/p>\n<p>You&#8217;re all running regular consistency checks, right?<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19,22,65],"tags":[],"class_list":["post-748","post","type-post","status-publish","format-standard","hentry","category-bugfixes","category-checkdb-from-every-angle","category-partitioning"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>DBCC CHECKFILEGROUP bug fixed in 2008 SP1 CU6 - Paul S. Randal<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/dbcc-checkfilegroup-bug-fixed-in-2008-sp1-cu6\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DBCC CHECKFILEGROUP bug fixed in 2008 SP1 CU6 - Paul S. Randal\" \/>\n<meta property=\"og:description\" content=\"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 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/paul\/dbcc-checkfilegroup-bug-fixed-in-2008-sp1-cu6\/\" \/>\n<meta property=\"og:site_name\" content=\"Paul S. Randal\" \/>\n<meta property=\"article:published_time\" content=\"2010-01-25T10:47:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-11-16T21:01:31+00:00\" \/>\n<meta name=\"author\" content=\"Paul Randal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Paul Randal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/dbcc-checkfilegroup-bug-fixed-in-2008-sp1-cu6\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/dbcc-checkfilegroup-bug-fixed-in-2008-sp1-cu6\/\",\"name\":\"DBCC CHECKFILEGROUP bug fixed in 2008 SP1 CU6 - Paul S. Randal\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\"},\"datePublished\":\"2010-01-25T10:47:00+00:00\",\"dateModified\":\"2017-11-16T21:01:31+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/dbcc-checkfilegroup-bug-fixed-in-2008-sp1-cu6\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/paul\/dbcc-checkfilegroup-bug-fixed-in-2008-sp1-cu6\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/dbcc-checkfilegroup-bug-fixed-in-2008-sp1-cu6\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DBCC CHECKFILEGROUP bug fixed in 2008 SP1 CU6\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\",\"name\":\"Paul S. Randal\",\"description\":\"In Recovery...\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\",\"name\":\"Paul Randal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g\",\"caption\":\"Paul Randal\"},\"sameAs\":[\"http:\/\/3.209.169.194\/blogs\/paul\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/author\/paul\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"DBCC CHECKFILEGROUP bug fixed in 2008 SP1 CU6 - Paul S. Randal","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.sqlskills.com\/blogs\/paul\/dbcc-checkfilegroup-bug-fixed-in-2008-sp1-cu6\/","og_locale":"en_US","og_type":"article","og_title":"DBCC CHECKFILEGROUP bug fixed in 2008 SP1 CU6 - Paul S. Randal","og_description":"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 [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/paul\/dbcc-checkfilegroup-bug-fixed-in-2008-sp1-cu6\/","og_site_name":"Paul S. Randal","article_published_time":"2010-01-25T10:47:00+00:00","article_modified_time":"2017-11-16T21:01:31+00:00","author":"Paul Randal","twitter_misc":{"Written by":"Paul Randal","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/dbcc-checkfilegroup-bug-fixed-in-2008-sp1-cu6\/","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/dbcc-checkfilegroup-bug-fixed-in-2008-sp1-cu6\/","name":"DBCC CHECKFILEGROUP bug fixed in 2008 SP1 CU6 - Paul S. Randal","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website"},"datePublished":"2010-01-25T10:47:00+00:00","dateModified":"2017-11-16T21:01:31+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/dbcc-checkfilegroup-bug-fixed-in-2008-sp1-cu6\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/paul\/dbcc-checkfilegroup-bug-fixed-in-2008-sp1-cu6\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/dbcc-checkfilegroup-bug-fixed-in-2008-sp1-cu6\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/paul\/"},{"@type":"ListItem","position":2,"name":"DBCC CHECKFILEGROUP bug fixed in 2008 SP1 CU6"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/","name":"Paul S. Randal","description":"In Recovery...","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/paul\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce","name":"Paul Randal","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g","caption":"Paul Randal"},"sameAs":["http:\/\/3.209.169.194\/blogs\/paul"],"url":"https:\/\/www.sqlskills.com\/blogs\/paul\/author\/paul\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/748","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/comments?post=748"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/748\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/media?parent=748"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/categories?post=748"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/tags?post=748"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}