{"id":1184,"date":"2017-03-13T22:11:08","date_gmt":"2017-03-13T16:41:08","guid":{"rendered":"http:\/\/pramodsingla.com\/?p=1184"},"modified":"2017-03-13T22:11:08","modified_gmt":"2017-03-13T16:41:08","slug":"database-consistency-check-dbcc-checkdb","status":"publish","type":"post","link":"https:\/\/pramodsingla.com\/?p=1184","title":{"rendered":"SQL Server &#8211; Database Consistency Check DBCC CheckDB"},"content":{"rendered":"<h2><strong>Problem:<\/strong> How to check the consistency of a SQL Server database.<\/h2>\n<h2><strong>Solution: <\/strong><\/h2>\n<blockquote>\n<h2><strong><span style=\"color:#0000ff;font-family:Courier New;font-size:small;\">DBCC<\/span><span style=\"color:#000000;font-family:'Courier New';font-size:small;font-style:normal;font-weight:normal;letter-spacing:normal;orphans:2;text-align:start;text-indent:0;text-transform:none;white-space:normal;widows:2;word-spacing:0;display:inline !important;float:none;\">\u00a0<\/span><span style=\"color:maroon;text-transform:none;text-indent:0;letter-spacing:normal;font-family:'Courier New';font-size:small;font-style:normal;font-weight:normal;word-spacing:0;white-space:normal;orphans:2;widows:2;\">checkdb<\/span><span style=\"color:#000000;font-family:'Courier New';font-size:small;font-style:normal;font-weight:normal;letter-spacing:normal;orphans:2;text-align:start;text-indent:0;text-transform:none;white-space:normal;widows:2;word-spacing:0;display:inline !important;float:none;\">\u00a0<\/span><span style=\"color:blue;text-transform:none;text-indent:0;letter-spacing:normal;font-family:'Courier New';font-size:small;font-style:normal;font-weight:normal;word-spacing:0;white-space:normal;orphans:2;widows:2;\">WITH<\/span><span style=\"color:#000000;font-family:'Courier New';font-size:small;font-style:normal;font-weight:normal;letter-spacing:normal;orphans:2;text-align:start;text-indent:0;text-transform:none;white-space:normal;widows:2;word-spacing:0;display:inline !important;float:none;\">\u00a0<\/span><span style=\"color:maroon;text-transform:none;text-indent:0;letter-spacing:normal;font-family:'Courier New';font-size:small;font-style:normal;font-weight:normal;word-spacing:0;white-space:normal;orphans:2;widows:2;\">no_infomsgs<\/span><span style=\"color:silver;text-transform:none;text-indent:0;letter-spacing:normal;font-family:'Courier New';font-size:small;font-style:normal;font-weight:normal;word-spacing:0;white-space:normal;orphans:2;widows:2;\">,<\/span><span style=\"color:#000000;font-family:'Courier New';font-size:small;font-style:normal;font-weight:normal;letter-spacing:normal;orphans:2;text-align:start;text-indent:0;text-transform:none;white-space:normal;widows:2;word-spacing:0;display:inline !important;float:none;\">\u00a0<\/span><span style=\"color:maroon;text-transform:none;text-indent:0;letter-spacing:normal;font-family:'Courier New';font-size:small;font-style:normal;font-weight:normal;word-spacing:0;white-space:normal;orphans:2;widows:2;\">all_errormsgs<\/span><span style=\"color:silver;text-transform:none;text-indent:0;letter-spacing:normal;font-family:'Courier New';font-size:small;font-style:normal;font-weight:normal;word-spacing:0;white-space:normal;orphans:2;widows:2;\">;<\/span><\/strong><\/h2>\n<\/blockquote>\n<ul>\n<li>\n<h2>This Command can put overhead on the database.<\/h2>\n<\/li>\n<li>\n<h2>Normally schedule to run at off peak hours.<\/h2>\n<\/li>\n<li>\n<h2>See the database consistency history report by right click the database&gt;select Reports&gt;Select Standard Reports&gt;Select Database Consistency history<\/h2>\n<\/li>\n<\/ul>\n<h2><a href=\"https:\/\/pramodsingla.files.wordpress.com\/2017\/03\/7.jpg\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-1191\" src=\"https:\/\/pramodsingla.files.wordpress.com\/2017\/03\/7.jpg\" alt=\"\" width=\"999\" height=\"596\" srcset=\"https:\/\/pramodsingla.com\/wp-content\/uploads\/2017\/03\/7.jpg 999w, https:\/\/pramodsingla.com\/wp-content\/uploads\/2017\/03\/7-300x179.jpg 300w, https:\/\/pramodsingla.com\/wp-content\/uploads\/2017\/03\/7-768x458.jpg 768w\" sizes=\"(max-width: 999px) 100vw, 999px\" \/><\/a><\/h2>\n<h2 style=\"text-align:center;\">Figure 1: Database Consistency History<\/h2>\n<h2><\/h2>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Problem: How to check the consistency of a SQL Server database. Solution: DBCC\u00a0checkdb\u00a0WITH\u00a0no_infomsgs,\u00a0all_errormsgs; This Command can put overhead on the[&#8230;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_mi_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[1],"tags":[65,72,168],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/pramodsingla.com\/index.php?rest_route=\/wp\/v2\/posts\/1184"}],"collection":[{"href":"https:\/\/pramodsingla.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pramodsingla.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pramodsingla.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pramodsingla.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1184"}],"version-history":[{"count":0,"href":"https:\/\/pramodsingla.com\/index.php?rest_route=\/wp\/v2\/posts\/1184\/revisions"}],"wp:attachment":[{"href":"https:\/\/pramodsingla.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1184"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pramodsingla.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1184"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pramodsingla.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1184"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}