{"id":608,"date":"2014-02-17T10:31:19","date_gmt":"2014-02-17T10:31:19","guid":{"rendered":"http:\/\/sysinfotools.com\/blog\/?p=608"},"modified":"2025-12-09T09:14:01","modified_gmt":"2025-12-09T09:14:01","slug":"dbcc-checkdb-ms-sql-server","status":"publish","type":"post","link":"https:\/\/www.sysinfotools.com\/blog\/dbcc-checkdb-ms-sql-server\/","title":{"rendered":"What is DBCC CHECKDB And What Does it Do?"},"content":{"rendered":"<div class=\"block_sum\"><strong>Summary:-<\/strong> SQL Server database corruption can be the biggest problem and can cause serious damage to a database. There are a few ways and <a href=\"https:\/\/www.sysinfotools.com\/recovery\/ms-sql-database-recovery.php\"><strong>SQL Database Recovery<\/strong><\/a> Tool to detect database corruption, but here we will focus more on DBCC CHECKDB. In this article, we will discuss what DBCC CHECKDB does and what it does. So, before moving further, let\u2019s first know about it.<\/p>\n<p class=\"blog-btn\"><a class=\"sum-d-btn\" href=\"https:\/\/www.sysinfotools.com\/demo-version\/SysInfoTools-MS-SQL-Database-Recovery.exe\"><i class=\"icon-windows\"><\/i>  Download<\/a>   <a class=\"sum-b-btn\" href=\"https:\/\/www.sysinfotools.com\/buynow\/ms-sql-database-recovery.php\"><i class=\"icon icon-basket\"><\/i>  Buy Now<\/a><\/p>\n<\/div>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_81 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<div class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/div>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.sysinfotools.com\/blog\/dbcc-checkdb-ms-sql-server\/#What_is_DBCC_CHECKDB\" >What is DBCC CHECKDB?<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.sysinfotools.com\/blog\/dbcc-checkdb-ms-sql-server\/#What_Does_DBCC_CHECKDB_Do\" >What Does DBCC CHECKDB Do?<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.sysinfotools.com\/blog\/dbcc-checkdb-ms-sql-server\/#How_to_use_SQL_Server_DBCC_CHECKDB\" >How to use SQL Server DBCC CHECKDB?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.sysinfotools.com\/blog\/dbcc-checkdb-ms-sql-server\/#How_to_Repair_SQL_Server_Database_if_it_gets_Corrupted\" >How to Repair SQL Server Database if it gets Corrupted?<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.sysinfotools.com\/blog\/dbcc-checkdb-ms-sql-server\/#Is_There_Any_Alternative_to_DBCC_CHECKDB\" >Is There Any Alternative to DBCC CHECKDB?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.sysinfotools.com\/blog\/dbcc-checkdb-ms-sql-server\/#Conclusion\" >Conclusion<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"What_is_DBCC_CHECKDB\"><\/span>What is DBCC CHECKDB?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\">DBCC stands for Database Consistency Checker. It acts as database console commands which means they are used to check the consistency of the SQL server database. They maintain databases, tables, file groups, and indexes. It also checks the logical and physical integrity of all the objects in the specified database by performing the following operations:<\/p>\n<ul>\n<li>Runs DBCC CHECKALLOC on the database- it checks the consistency of disk space allocation.<\/li>\n<li>Runs DBCC CHECKTABLE on every table and view in the database.<\/li>\n<li>Runs DBCC on the database.<\/li>\n<li>Validates the contents of every indexed view in the database.<\/li>\n<li>Validates link-level consistency between table metadata and file system directories and files when storing varbinary(max) data in the file system using FILESTREAM.<\/li>\n<li>Validates the Service Broker data in the database.<\/li>\n<\/ul>\n<p>If you have ever run DBCC CHECKDB, you must know that it takes some time for large databases.<\/p>\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"What_Does_DBCC_CHECKDB_Do\"><\/span>What Does DBCC CHECKDB Do?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\">Data corruption can cause all sorts of issues within the database. It may include incorrect data results and failed SQL statements, and in some cases, it takes down the entire SQL instance. Therefore, DBCC CHECKDB warns you of corruption so that you can fix it before it gets too bad.<\/p>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"How_to_use_SQL_Server_DBCC_CHECKDB\"><\/span>How to use SQL Server DBCC CHECKDB?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>It is quite simple, you just need to run the below statement, and the basic syntax looks like this:<\/p>\n<p><strong>DBCC CHECKDB (\u2018DatabaseName\u2019)<\/strong><\/p>\n<p>But obviously, you don\u2019t want to log in every morning and run this statement on each database, so you must automate this process using a few different methods.<\/p>\n<p>Do not panic; just check backups. DBCC CHECKDB errors usually indicate what needs to be done.<\/p>\n<p><img decoding=\"async\" class=\"size-full wp-image-6693 alignnone\" src=\"https:\/\/www.sysinfotools.com\/blog\/wp-content\/uploads\/2014\/02\/images-1.png\" sizes=\"(max-width: 452px) 100vw, 452px\" \/><\/p>\n<p><img decoding=\"async\" class=\"size-full wp-image-6693 alignnone\" src=\"https:\/\/www.sysinfotools.com\/blog\/wp-content\/uploads\/2014\/02\/images-2.png\" sizes=\"(max-width: 452px) 100vw, 452px\" \/><\/p>\n<ul>\n<li>In the first error, a DBCC UPDATEUSAGE will correct the page and row count inaccuracies in the catalog view.<\/li>\n<li>The second error shows data corruption and mentions using repair_allow_data_loss as the minimum repair level. The user can run the statement with this argument but may lose data. That is why I would recommend restoring to a backup. It would be best to ensure the backup does not contain any corrupted data.<\/li>\n<\/ul>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"How_to_Repair_SQL_Server_Database_if_it_gets_Corrupted\"><\/span>How to Repair SQL Server Database if it gets Corrupted?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\">If you do not have a backup, then you may need to use DBCC CHECKDB with a repair option. So, here are the repair options that are available to use. They may or may not work and should be used as a last option.<\/p>\n<ul>\n<li>REPAIR_ALLOW_DATA_LOSS:- It tries to repair all reported errors, but these repairs can cause data loss.<\/li>\n<li>REPAIR_REBUILD:- It performs repairs that have no possibility of data loss. It includes quick repairs, like repairing missing rows in non-clustered indexes, and more time-consuming repairs, such as rebuilding an index.<\/li>\n<\/ul>\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Is_There_Any_Alternative_to_DBCC_CHECKDB\"><\/span>Is There Any Alternative to DBCC CHECKDB?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\">Yes, of course, an alternate solution exists when Repair_Allow_Data_Loss does not work. Correcting errors by using the REPAIR_ALLOW_DATA_LOSS clause can result in data loss. So, to prevent data loss, you should make use of an automated tool.<\/p>\n<p><strong>Sysinfo SQL Database Recovery <\/strong>provides the facility to recover the file objects, including tables, views, stored procedures, programmability, triggers, default, and functions.<\/p>\n<p style=\"text-align: justify;\">It saves the recovered data in the SQL Server database or a compatible script format. This tool can <a href=\"https:\/\/www.sysinfotools.com\/blog\/sql-database-restore-error-5243\/\"><strong>solve SQL Database Restore Error 5243<\/strong><\/a>. It also supports SQL server compressions and deals with SQL Server corruption with great ease.<\/p>\n<h4 class=\"wp-block-heading\">Simple Steps to Repair a SQL Server Database<\/h4>\n<ol>\n<li>Download &amp; Run SysInfo SQL Database Recovery Tool.<\/li>\n<li>Click Open to browse the SQL database files( MDF &amp; NDF)<\/li>\n<li>Select the Recover mode to scan database files.<\/li>\n<li>Click on the OK button to start the scanning process.<\/li>\n<li>Double-click on the folders to preview them before saving.<\/li>\n<li>Click on the Save button to continue further.<\/li>\n<li>Now, enter SQL Server account credentials and check the database connectivity.<\/li>\n<li>Finally, click the OK button to save the recovered SQL database successfully.<\/li>\n<\/ol>\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span>Conclusion<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\">Through this blog, we understood what DBCC CHECKDB does and how it helps to repair a SQL Server database. Above, I have also described the automated tool that can recover data from the corrupt SQL server database files and restore it into SQL Server and SQL compatible script. Hope it helps.<\/p>\n<p><strong>Read Also:<\/strong> <a href=\"https:\/\/www.sysinfotools.com\/blog\/repair-master-database-sql-server\/\">Repair Master Database<\/a><\/p>\n\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-left kksr-valign-bottom\"\n    data-payload='{&quot;align&quot;:&quot;left&quot;,&quot;id&quot;:&quot;608&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;bottom&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;1&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;5&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (1 vote)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;What is DBCC CHECKDB And What Does it Do?&quot;,&quot;width&quot;:&quot;142.5&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 142.5px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            5\/5 - (1 vote)    <\/div>\n    <\/div>\n","protected":false},"excerpt":{"rendered":"<p>Summary:- SQL Server database corruption can be the biggest problem and can cause serious damage to a database. There are<a class=\"read-more ml-1 main-read-more\" href=\"https:\/\/www.sysinfotools.com\/blog\/dbcc-checkdb-ms-sql-server\/\">Read More<\/a><\/p>\n","protected":false},"author":1,"featured_media":7128,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[159],"tags":[],"class_list":["post-608","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft-windows"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>What does DBCC CHECKDB do in MS SQL Server?<\/title>\n<meta name=\"description\" content=\"Learn different database Console Commands or DBCC. Specially, read about what DBCC CHECKDB do in MS SQL Server.\" \/>\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.sysinfotools.com\/blog\/dbcc-checkdb-ms-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What does DBCC CHECKDB do in MS SQL Server?\" \/>\n<meta property=\"og:description\" content=\"Learn different database Console Commands or DBCC. Specially, read about what DBCC CHECKDB do in MS SQL Server.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sysinfotools.com\/blog\/dbcc-checkdb-ms-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"SysinfoTools Tech Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/sysinfotools\" \/>\n<meta property=\"article:published_time\" content=\"2014-02-17T10:31:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-12-09T09:14:01+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sysinfotools.com\/blog\/wp-content\/uploads\/2014\/02\/What-is-DBCC-CHECKDB-and-What-does-it-do.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"698\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Simran Bhatia\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Simran Bhatia\" \/>\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\":\"Article\",\"@id\":\"https:\/\/www.sysinfotools.com\/blog\/dbcc-checkdb-ms-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.sysinfotools.com\/blog\/dbcc-checkdb-ms-sql-server\/\"},\"author\":{\"name\":\"Simran Bhatia\",\"@id\":\"https:\/\/www.sysinfotools.com\/blog\/#\/schema\/person\/0bc86a610ba204e43dcf67ac0c4f422a\"},\"headline\":\"What is DBCC CHECKDB And What Does it Do?\",\"datePublished\":\"2014-02-17T10:31:19+00:00\",\"dateModified\":\"2025-12-09T09:14:01+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.sysinfotools.com\/blog\/dbcc-checkdb-ms-sql-server\/\"},\"wordCount\":787,\"publisher\":{\"@id\":\"https:\/\/www.sysinfotools.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.sysinfotools.com\/blog\/dbcc-checkdb-ms-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.sysinfotools.com\/blog\/wp-content\/uploads\/2014\/02\/What-is-DBCC-CHECKDB-and-What-does-it-do.jpg\",\"articleSection\":[\"Microsoft Windows\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sysinfotools.com\/blog\/dbcc-checkdb-ms-sql-server\/\",\"url\":\"https:\/\/www.sysinfotools.com\/blog\/dbcc-checkdb-ms-sql-server\/\",\"name\":\"What does DBCC CHECKDB do in MS SQL Server?\",\"isPartOf\":{\"@id\":\"https:\/\/www.sysinfotools.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.sysinfotools.com\/blog\/dbcc-checkdb-ms-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.sysinfotools.com\/blog\/dbcc-checkdb-ms-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.sysinfotools.com\/blog\/wp-content\/uploads\/2014\/02\/What-is-DBCC-CHECKDB-and-What-does-it-do.jpg\",\"datePublished\":\"2014-02-17T10:31:19+00:00\",\"dateModified\":\"2025-12-09T09:14:01+00:00\",\"description\":\"Learn different database Console Commands or DBCC. Specially, read about what DBCC CHECKDB do in MS SQL Server.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sysinfotools.com\/blog\/dbcc-checkdb-ms-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sysinfotools.com\/blog\/dbcc-checkdb-ms-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sysinfotools.com\/blog\/dbcc-checkdb-ms-sql-server\/#primaryimage\",\"url\":\"https:\/\/www.sysinfotools.com\/blog\/wp-content\/uploads\/2014\/02\/What-is-DBCC-CHECKDB-and-What-does-it-do.jpg\",\"contentUrl\":\"https:\/\/www.sysinfotools.com\/blog\/wp-content\/uploads\/2014\/02\/What-is-DBCC-CHECKDB-and-What-does-it-do.jpg\",\"width\":698,\"height\":400,\"caption\":\"DBCC-CHECKDB Command\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sysinfotools.com\/blog\/dbcc-checkdb-ms-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sysinfotools.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"What is DBCC CHECKDB And What Does it Do?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sysinfotools.com\/blog\/#website\",\"url\":\"https:\/\/www.sysinfotools.com\/blog\/\",\"name\":\"SysinfoTools Tech Blog\",\"description\":\"Overview of Trending Technology Issues and Challenges\",\"publisher\":{\"@id\":\"https:\/\/www.sysinfotools.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sysinfotools.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.sysinfotools.com\/blog\/#organization\",\"name\":\"SysinfoTools\",\"url\":\"https:\/\/www.sysinfotools.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sysinfotools.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.sysinfotools.com\/blog\/wp-content\/uploads\/2024\/07\/logo-new.webp\",\"contentUrl\":\"https:\/\/www.sysinfotools.com\/blog\/wp-content\/uploads\/2024\/07\/logo-new.webp\",\"width\":235,\"height\":61,\"caption\":\"SysinfoTools\"},\"image\":{\"@id\":\"https:\/\/www.sysinfotools.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/sysinfotools\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sysinfotools.com\/blog\/#\/schema\/person\/0bc86a610ba204e43dcf67ac0c4f422a\",\"name\":\"Simran Bhatia\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/640214467911604daca4d8657c68321260a2bb37049f372d203fa8fe6218dc5d?s=96&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/640214467911604daca4d8657c68321260a2bb37049f372d203fa8fe6218dc5d?s=96&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/640214467911604daca4d8657c68321260a2bb37049f372d203fa8fe6218dc5d?s=96&r=g\",\"caption\":\"Simran Bhatia\"},\"description\":\"Simran Bhatia is a technical content writer engaged in writing clear, concise, and SEO-optimized content. With a background in computer science and a passion for writing, I thrive to deliver complex technical content in simple layman terms.\",\"sameAs\":[\"https:\/\/www.sysinfotools.com\/\",\"https:\/\/www.linkedin.com\/in\/simran-bhatia-190169299\"],\"url\":\"https:\/\/www.sysinfotools.com\/blog\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What does DBCC CHECKDB do in MS SQL Server?","description":"Learn different database Console Commands or DBCC. Specially, read about what DBCC CHECKDB do in MS SQL Server.","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.sysinfotools.com\/blog\/dbcc-checkdb-ms-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"What does DBCC CHECKDB do in MS SQL Server?","og_description":"Learn different database Console Commands or DBCC. Specially, read about what DBCC CHECKDB do in MS SQL Server.","og_url":"https:\/\/www.sysinfotools.com\/blog\/dbcc-checkdb-ms-sql-server\/","og_site_name":"SysinfoTools Tech Blog","article_publisher":"https:\/\/www.facebook.com\/sysinfotools","article_published_time":"2014-02-17T10:31:19+00:00","article_modified_time":"2025-12-09T09:14:01+00:00","og_image":[{"width":698,"height":400,"url":"https:\/\/www.sysinfotools.com\/blog\/wp-content\/uploads\/2014\/02\/What-is-DBCC-CHECKDB-and-What-does-it-do.jpg","type":"image\/jpeg"}],"author":"Simran Bhatia","twitter_misc":{"Written by":"Simran Bhatia","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.sysinfotools.com\/blog\/dbcc-checkdb-ms-sql-server\/#article","isPartOf":{"@id":"https:\/\/www.sysinfotools.com\/blog\/dbcc-checkdb-ms-sql-server\/"},"author":{"name":"Simran Bhatia","@id":"https:\/\/www.sysinfotools.com\/blog\/#\/schema\/person\/0bc86a610ba204e43dcf67ac0c4f422a"},"headline":"What is DBCC CHECKDB And What Does it Do?","datePublished":"2014-02-17T10:31:19+00:00","dateModified":"2025-12-09T09:14:01+00:00","mainEntityOfPage":{"@id":"https:\/\/www.sysinfotools.com\/blog\/dbcc-checkdb-ms-sql-server\/"},"wordCount":787,"publisher":{"@id":"https:\/\/www.sysinfotools.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.sysinfotools.com\/blog\/dbcc-checkdb-ms-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sysinfotools.com\/blog\/wp-content\/uploads\/2014\/02\/What-is-DBCC-CHECKDB-and-What-does-it-do.jpg","articleSection":["Microsoft Windows"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.sysinfotools.com\/blog\/dbcc-checkdb-ms-sql-server\/","url":"https:\/\/www.sysinfotools.com\/blog\/dbcc-checkdb-ms-sql-server\/","name":"What does DBCC CHECKDB do in MS SQL Server?","isPartOf":{"@id":"https:\/\/www.sysinfotools.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sysinfotools.com\/blog\/dbcc-checkdb-ms-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/www.sysinfotools.com\/blog\/dbcc-checkdb-ms-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sysinfotools.com\/blog\/wp-content\/uploads\/2014\/02\/What-is-DBCC-CHECKDB-and-What-does-it-do.jpg","datePublished":"2014-02-17T10:31:19+00:00","dateModified":"2025-12-09T09:14:01+00:00","description":"Learn different database Console Commands or DBCC. Specially, read about what DBCC CHECKDB do in MS SQL Server.","breadcrumb":{"@id":"https:\/\/www.sysinfotools.com\/blog\/dbcc-checkdb-ms-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sysinfotools.com\/blog\/dbcc-checkdb-ms-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sysinfotools.com\/blog\/dbcc-checkdb-ms-sql-server\/#primaryimage","url":"https:\/\/www.sysinfotools.com\/blog\/wp-content\/uploads\/2014\/02\/What-is-DBCC-CHECKDB-and-What-does-it-do.jpg","contentUrl":"https:\/\/www.sysinfotools.com\/blog\/wp-content\/uploads\/2014\/02\/What-is-DBCC-CHECKDB-and-What-does-it-do.jpg","width":698,"height":400,"caption":"DBCC-CHECKDB Command"},{"@type":"BreadcrumbList","@id":"https:\/\/www.sysinfotools.com\/blog\/dbcc-checkdb-ms-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sysinfotools.com\/blog\/"},{"@type":"ListItem","position":2,"name":"What is DBCC CHECKDB And What Does it Do?"}]},{"@type":"WebSite","@id":"https:\/\/www.sysinfotools.com\/blog\/#website","url":"https:\/\/www.sysinfotools.com\/blog\/","name":"SysinfoTools Tech Blog","description":"Overview of Trending Technology Issues and Challenges","publisher":{"@id":"https:\/\/www.sysinfotools.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sysinfotools.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.sysinfotools.com\/blog\/#organization","name":"SysinfoTools","url":"https:\/\/www.sysinfotools.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sysinfotools.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.sysinfotools.com\/blog\/wp-content\/uploads\/2024\/07\/logo-new.webp","contentUrl":"https:\/\/www.sysinfotools.com\/blog\/wp-content\/uploads\/2024\/07\/logo-new.webp","width":235,"height":61,"caption":"SysinfoTools"},"image":{"@id":"https:\/\/www.sysinfotools.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/sysinfotools"]},{"@type":"Person","@id":"https:\/\/www.sysinfotools.com\/blog\/#\/schema\/person\/0bc86a610ba204e43dcf67ac0c4f422a","name":"Simran Bhatia","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/640214467911604daca4d8657c68321260a2bb37049f372d203fa8fe6218dc5d?s=96&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/640214467911604daca4d8657c68321260a2bb37049f372d203fa8fe6218dc5d?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/640214467911604daca4d8657c68321260a2bb37049f372d203fa8fe6218dc5d?s=96&r=g","caption":"Simran Bhatia"},"description":"Simran Bhatia is a technical content writer engaged in writing clear, concise, and SEO-optimized content. With a background in computer science and a passion for writing, I thrive to deliver complex technical content in simple layman terms.","sameAs":["https:\/\/www.sysinfotools.com\/","https:\/\/www.linkedin.com\/in\/simran-bhatia-190169299"],"url":"https:\/\/www.sysinfotools.com\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sysinfotools.com\/blog\/wp-json\/wp\/v2\/posts\/608","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sysinfotools.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sysinfotools.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sysinfotools.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sysinfotools.com\/blog\/wp-json\/wp\/v2\/comments?post=608"}],"version-history":[{"count":9,"href":"https:\/\/www.sysinfotools.com\/blog\/wp-json\/wp\/v2\/posts\/608\/revisions"}],"predecessor-version":[{"id":20054,"href":"https:\/\/www.sysinfotools.com\/blog\/wp-json\/wp\/v2\/posts\/608\/revisions\/20054"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sysinfotools.com\/blog\/wp-json\/wp\/v2\/media\/7128"}],"wp:attachment":[{"href":"https:\/\/www.sysinfotools.com\/blog\/wp-json\/wp\/v2\/media?parent=608"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sysinfotools.com\/blog\/wp-json\/wp\/v2\/categories?post=608"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sysinfotools.com\/blog\/wp-json\/wp\/v2\/tags?post=608"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}