{"id":463,"date":"2012-11-15T12:53:00","date_gmt":"2012-11-15T12:53:00","guid":{"rendered":"\/blogs\/erin\/post\/What-Checks-Update-dbccLastKnownGood.aspx"},"modified":"2018-12-14T09:11:08","modified_gmt":"2018-12-14T17:11:08","slug":"what-checks-update-dbcclastknowngood","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/erin\/what-checks-update-dbcclastknowngood\/","title":{"rendered":"What Checks Update dbccLastKnownGood?"},"content":{"rendered":"

One of the methods I’ve used to check when a client last ran DBCC CHECKDB<\/a> on their database is the dbccLastKnownGood value on the boot page (page 9 in the PRIMARY file).\u00a0 When working with a client a couple weeks ago, the value for dbccclastknowngood was from 2006, but the customer stated they were running integrity checks.\u00a0 When I investigated their method for checks, I discovered that due to the database size they were running DBCC CHECKALLOC and DBCC CHECKCATALOG weekly, and checking different user tables with DBCC CHECKTABLE at night.\u00a0 Breaking out the checks between the different commands does not update dbccLastKnownGood – running CHECKDB is the only thing that does.\u00a0 Let’s have a look\u2026<\/p>\n

I have a copy of the AdventureWorks2012 database installed, and I can look at the boot page using DBCC PAGE<\/a> or DBCC DBINFO<\/a>.\u00a0 Both commands are undocumented, but as Paul notes in the links provided, they are safe to run.\u00a0 I’ll use DBINFO:<\/p>\n

\r\nDBCC TRACEON (3604);\r\nGO\r\nDBCC DBINFO ('AdventureWorks2012');\r\nGO\r\n<\/pre>\n
The text below is a snippet of the output to show only what’s relevant:<\/p>\n
<\/p>\n
<\/p>\n
\n
dbi_dbmOldestXactLsn = 0:0:0 (0x00000000:00000000:0000)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>dbi_CloneCpuCount = 0<\/span><\/p>\n
dbi_CloneMemorySize = 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>dbi_updSysCatalog = 1900-01-01
\n00:00:00.000<\/span><\/p>\n
dbi_LogBackupChainOrigin = 0:0:0
\n(0x00000000:00000000:0000)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/p>\n
dbi_dbccLastKnownGood = 1900<\/span>–0<\/span>1-01 00<\/span>:00<\/span>:00<\/span>.000<\/span><\/span><\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span>dbi_roleSequence
\n= 0<\/span><\/p>\n
dbi_dbmHardenedLsn = 0:0:0 (0x00000000:00000000:0000)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>dbi_localState = 0<\/span><\/p>\n
dbi_safety = 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>dbi_modDate = 2012-11-15
\n09:42:47.813<\/span><\/p>\n
dbi_verRDB = 184552376\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>dbi_lazyCommitOption = 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/p>\n
dbi_svcBrokerGUID = 10048a46-646c-4c44-8037-8ea6c83f4e2c\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>dbi_svcBrokerOptions =
\n0x00000001<\/span><\/p>\n<\/blockquote>\n
If we run DBCC CHECKALLOC, DBCC CHECKCATALOG, and DBCC CHECKTABLE for all system and user tables, you can see that dbccLastKnownGood good does not change (please don\u2019t holler because I\u2019m using a cursor\u2026it does what I need for this example!):<\/p>\n
\r\nDBCC CHECKALLOC ('AdventureWorks2012') WITH ALL_ERRORMSGS, NO_INFOMSGS;\r\nGO\r\n\r\nDBCC CHECKCATALOG ('AdventureWorks2012');\r\nGO\r\n\r\nUSE [AdventureWorks2012];\r\nGO\r\n\r\nDECLARE @schemaname varchar(500);\r\nDECLARE @tablename varchar(500);\r\nDECLARE @fulltable varchar(1000);\r\nDECLARE @string varchar(5000); <\/span>\r\n\r\nDECLARE TableList CURSOR FOR\r\nSELECT [ss].[name],[so].[name]\r\nFROM [sys].[objects] AS so\r\nJOIN [sys].[schemas] AS ss ON [so].[schema_id]=[ss].[schema_id]\r\nWHERE [so].[type] in ('S','U')\r\nORDER BY [so].[name]; \r\n\r\nBEGIN\r\nOPEN TableList\r\n\r\nFETCH NEXT FROM TableList\r\nINTO @schemaname, @tablename;\r\n\r\nWHILE @@FETCH_STATUS = 0>\r\nBEGIN\r\nSET @fulltable = @schemaname + '.' + @tablename;\r\nSET @string = N'DBCC CHECKTABLE (''' + @fulltable + ''') WITH ALL_ERRORMSGS, NO_INFOMSGS;'\r\nEXEC (@string)\r\nFETCH NEXT FROM TableList\r\nINTO @schemaname, @tablename;\r\nEND \r\n\r\nCLOSE TableList;\r\nDEALLOCATE TableList;\r\nEND\r\n\r\n<sDBCC DBINFO ('AdventureWorks2012');\r\nGO\r\n<\/pre>\n
Output:<\/p>\n
\n
dbi_dbmOldestXactLsn = 0:0:0 (0x00000000:00000000:0000)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>dbi_CloneCpuCount = 0<\/span><\/p>\n
dbi_CloneMemorySize = 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>dbi_updSysCatalog = 1900-01-01
\n00:00:00.000<\/span><\/p>\n
dbi_LogBackupChainOrigin = 0:0:0
\n(0x00000000:00000000:0000)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/p>\n
dbi_dbccLastKnownGood = 1900<\/span>–0<\/span>1-01 00<\/span>:00<\/span>:00<\/span>.000<\/span> \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span>dbi_roleSequence
\n= 0<\/span><\/p>\n
dbi_dbmHardenedLsn = 0:0:0 (0x00000000:00000000:0000)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>dbi_localState = 0<\/span><\/p>\n
dbi_safety = 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>dbi_modDate = 2012-11-15
\n09:42:47.813<\/span><\/p>\n
dbi_verRDB = 184552376\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>dbi_lazyCommitOption = 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/p>\n
dbi_svcBrokerGUID = 10048a46-646c-4c44-8037-8ea6c83f4e2c\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>dbi_svcBrokerOptions =
\n0x0000000<\/span><\/p><\/blockquote>\n
No change in dbccLastKnownGood.\u00a0 What happens if we run DBCC CHECKFILEGROUP?\u00a0 I created a second filegroup in the AdventureWorks2012 database and created one table in the filegroup, then ran the check on that filegroup:<\/p>\n
\r\nALTER DATABASE [AdventureWorks2012]\r\nADD FILEGROUP [TestFG]; \r\n\r\nALTER DATABASE [AdventureWorks2012]\r\nADD FILE ( NAME = N'TestFile', FILENAME = N'D:\\Databases\\SQL2012\\AdventureWorks2012\\TestFile.ndf' ,\r\nSIZE = 4096KB , FILEGROWTH = 1024KB )\r\nTO FILEGROUP [TestFG];\r\n\r\nCREATE TABLE [dbo].[test] (\r\n[col1] INT,\r\n[col2] INT\r\n)\r\nON [TestFG]; \r\n\r\nINSERT INTO [dbo].[test] (\r\ncol1,\r\ncol2\r\n)\r\nVALUES\r\n(1,2),\r\n(3,4); \r\n\r\nDBCC CHECKFILEGROUP (2) WITH ALL_ERRORMSGS, NO_INFOMSGS;\r\nGO\r\nDBCC DBINFO ('AdventureWorks2012');\r\nGO\r\n<\/pre>\n<\/blockquote>\n
Output:<\/p>\n
\n
dbi_dbmOldestXactLsn = 0:0:0 (0x00000000:00000000:0000)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>dbi_CloneCpuCount = 0<\/span><\/p>\n
dbi_CloneMemorySize = 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>dbi_updSysCatalog = 1900-01-01
\n00:00:00.000<\/span><\/p>\n
dbi_LogBackupChainOrigin = 0:0:0
\n(0x00000000:00000000:0000)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/p>\n
dbi_dbccLastKnownGood = 2012-11-15
\n12:2<\/span>5:34<\/span>.090<\/span> \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span>dbi_roleSequence
\n= 0<\/span><\/p>\n
dbi_dbmHardenedLsn = 0:0:0 (0x00000000:00000000:0000)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>dbi_localState = 0<\/span><\/p>\n
dbi_safety = 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>dbi_modDate = 2012-11-15
\n09:42:47.813<\/span><\/p>\n
dbi_verRDB = 184552376\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>dbi_lazyCommitOption = 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/p>\n
dbi_svcBrokerGUID = 10048a46-646c-4c44-8037-8ea6c83f4e2c\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>dbi_svcBrokerOptions =
\n0x0000000<\/span><\/p><\/blockquote>\n
Look at that, it updated.\u00a0 And finally, we know that CHECKDB will update the value, but what happens if we include the WITH PHYSICAL_ONLY option, where the checks are not quite as involved? (See Paul\u2019s post<\/a> on check options for VLDBs for additional notes on WITH PHYSICAL_ONLY.)<\/p>\n
\r\nDBCC CHECKDB ('AdventureWorks2012') WITH PHYSICAL_ONLY;\r\nGO\r\nDBCC DBINFO ('AdventureWorks2012');\r\nGO\r\n<\/pre>\n
Output:<\/p>\n
\n
dbi_dbmOldestXactLsn = 0:0:0 (0x00000000:00000000:0000)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>dbi_CloneCpuCount = 0<\/span><\/p>\n
dbi_CloneMemorySize = 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>dbi_updSysCatalog = 1900-01-01
\n00:00:00.000<\/span><\/p>\n
dbi_LogBackupChainOrigin = 0:0:0
\n(0x00000000:00000000:0000)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/p>\n
dbi_dbccLastKnownGood = 2012-11-15
\n12:45:21.173\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span>dbi_roleSequence
\n= 0<\/span><\/p>\n
dbi_dbmHardenedLsn = 0:0:0 (0x00000000:00000000:0000)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>dbi_localState = 0<\/span><\/p>\n
dbi_safety = 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>dbi_modDate = 2012-11-15
\n09:42:47.813<\/span><\/p>\n
dbi_verRDB = 184552376\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>dbi_lazyCommitOption = 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/p>\n
dbi_svcBrokerGUID = 10048a46-646c-4c44-8037-8ea6c83f4e2c\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>dbi_svcBrokerOptions =
\n0x0000000<\/span><\/p><\/blockquote>\n
The dbccLastKnownGood value does update, as it does with CHECKDB without the PHYSICAL_ONLY.\u00a0 Therefore, if you\u2019re relying on dbccLastKnownGood to tell you when CHECKDB was last run, realize it may not give you the entire story.<\/p>\n
Note: post edited 11\/16\/2012 to replace screen shots of DBCC DBINFO output with text, as the images did not render well in all browsers.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"
One of the methods I’ve used to check when a client last ran DBCC CHECKDB on their database is the dbccLastKnownGood value on the boot page (page 9 in the PRIMARY file).\u00a0 When working with a client a couple weeks ago, the value for dbccclastknowngood was from 2006, but the customer stated they were running […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13],"tags":[],"yoast_head":"\nWhat DBCC Checks Update dbccLastKnownGood?<\/title>\n<meta name=\"description\" content=\"There are specific SQL Server DBCC checks which update dbccLastKnownGood on the boot page of the database, and it's not all of them!\" \/>\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\/erin\/what-checks-update-dbcclastknowngood\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What DBCC Checks Update dbccLastKnownGood?\" \/>\n<meta property=\"og:description\" content=\"There are specific SQL Server DBCC checks which update dbccLastKnownGood on the boot page of the database, and it's not all of them!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/erin\/what-checks-update-dbcclastknowngood\/\" \/>\n<meta property=\"og:site_name\" content=\"Erin Stellato\" \/>\n<meta property=\"article:published_time\" content=\"2012-11-15T12:53:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-12-14T17:11:08+00:00\" \/>\n<meta name=\"author\" content=\"Erin Stellato\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Erin Stellato\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/what-checks-update-dbcclastknowngood\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/what-checks-update-dbcclastknowngood\/\",\"name\":\"What DBCC Checks Update dbccLastKnownGood?\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#website\"},\"datePublished\":\"2012-11-15T12:53:00+00:00\",\"dateModified\":\"2018-12-14T17:11:08+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/76170223ffffa1df03fd9be5b66cb158\"},\"description\":\"There are specific SQL Server DBCC checks which update dbccLastKnownGood on the boot page of the database, and it's not all of them!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/what-checks-update-dbcclastknowngood\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/erin\/what-checks-update-dbcclastknowngood\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/what-checks-update-dbcclastknowngood\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"What Checks Update dbccLastKnownGood?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/\",\"name\":\"Erin Stellato\",\"description\":\"The SQL Sequel\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/76170223ffffa1df03fd9be5b66cb158\",\"name\":\"Erin Stellato\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0c8b485bd54ea26b57e99f79b525f409?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0c8b485bd54ea26b57e99f79b525f409?s=96&d=mm&r=g\",\"caption\":\"Erin Stellato\"},\"sameAs\":[\"http:\/\/3.209.169.194\/blogs\/erin\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/author\/erin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What DBCC Checks Update dbccLastKnownGood?","description":"There are specific SQL Server DBCC checks which update dbccLastKnownGood on the boot page of the database, and it's not all of them!","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\/erin\/what-checks-update-dbcclastknowngood\/","og_locale":"en_US","og_type":"article","og_title":"What DBCC Checks Update dbccLastKnownGood?","og_description":"There are specific SQL Server DBCC checks which update dbccLastKnownGood on the boot page of the database, and it's not all of them!","og_url":"https:\/\/www.sqlskills.com\/blogs\/erin\/what-checks-update-dbcclastknowngood\/","og_site_name":"Erin Stellato","article_published_time":"2012-11-15T12:53:00+00:00","article_modified_time":"2018-12-14T17:11:08+00:00","author":"Erin Stellato","twitter_misc":{"Written by":"Erin Stellato","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/what-checks-update-dbcclastknowngood\/","url":"https:\/\/www.sqlskills.com\/blogs\/erin\/what-checks-update-dbcclastknowngood\/","name":"What DBCC Checks Update dbccLastKnownGood?","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#website"},"datePublished":"2012-11-15T12:53:00+00:00","dateModified":"2018-12-14T17:11:08+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/76170223ffffa1df03fd9be5b66cb158"},"description":"There are specific SQL Server DBCC checks which update dbccLastKnownGood on the boot page of the database, and it's not all of them!","breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/what-checks-update-dbcclastknowngood\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/erin\/what-checks-update-dbcclastknowngood\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/what-checks-update-dbcclastknowngood\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/erin\/"},{"@type":"ListItem","position":2,"name":"What Checks Update dbccLastKnownGood?"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/erin\/","name":"Erin Stellato","description":"The SQL Sequel","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/erin\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/76170223ffffa1df03fd9be5b66cb158","name":"Erin Stellato","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/0c8b485bd54ea26b57e99f79b525f409?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0c8b485bd54ea26b57e99f79b525f409?s=96&d=mm&r=g","caption":"Erin Stellato"},"sameAs":["http:\/\/3.209.169.194\/blogs\/erin"],"url":"https:\/\/www.sqlskills.com\/blogs\/erin\/author\/erin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/posts\/463"}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/comments?post=463"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/posts\/463\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/media?parent=463"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/categories?post=463"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/tags?post=463"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}