{"id":1391,"date":"2018-09-25T11:07:32","date_gmt":"2018-09-25T18:07:32","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/glenn\/?p=1391"},"modified":"2018-09-25T11:07:32","modified_gmt":"2018-09-25T18:07:32","slug":"backup-checksum-feature-in-ssms-18-0-preview-4","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/glenn\/backup-checksum-feature-in-ssms-18-0-preview-4\/","title":{"rendered":"Backup Checksum Feature in SSMS 18.0 Preview 4"},"content":{"rendered":"<p>I was pleasantly surprised to see a new \u201cBackup checksum\u201d checkbox in the Server Properties, Database Settings dialog page (as shown in Figure 1). This was something that I had been asking for for quite awhile, so I appreciate that it has been added to SSMS.<\/p>\n<p>This simply provides tool support for the backup checksum default sp_configure option that was added in SQL Server 2014. This just adds the CHECKSUM keyword to your backup commands by default (in case you forgot to add it or some non-native backup solution is being used). You can override this default by specifying WITH NO_CHECKSUM in a backup command.<\/p>\n<p>This gives you a little bit of extra protection for your database backups, since the backup operation verifies each page for checksum and torn page, and generates a checksum for the entire backup. This is not a substitute for actually restoring you database backups on a regular basis, but it is a useful extra step to help ensure that your backups are actually good.<\/p>\n<p>Just to be clear, this is not new functionality, it just adds tool support in SSMS, so you don\u2019t have to use T-SQL to enable this setting. This makes it more likely that more people will start using backup checksums, which is a good thing.<\/p>\n<p>Microsoft has some more information about backup checksums:<\/p>\n<blockquote>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/backup-restore\/enable-or-disable-backup-checksums-during-backup-or-restore-sql-server?view=sql-server-2017\">Enable or Disable Backup Checksums During Backup or Restore (SQL Server)<\/a><\/p>\n<\/blockquote>\n<blockquote>\n<p><a href=\"https:\/\/support.microsoft.com\/en-us\/help\/2656988\/how-to-enable-the-checksum-option-if-backup-utilities-do-not-expose-th\">How to enable the CHECKSUM option if backup utilities do not expose the option<\/a><\/p>\n<\/blockquote>\n<p><font color=\"#666666\">Older versions of SQL Server can use trace flag 3023 to get the same effect.<\/font><\/p>\n<p><a href=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2018\/09\/image.png\"><img fetchpriority=\"high\" decoding=\"async\" title=\"image\" style=\"border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px\" border=\"0\" alt=\"image\" src=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2018\/09\/image_thumb.png\" width=\"849\" height=\"772\"><\/a><\/p>\n<p><strong>Figure 1: SSMS 18.0 Server Properties, Database Settings Dialog<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>I was pleasantly surprised to see a new \u201cBackup checksum\u201d checkbox in the Server Properties, Database Settings dialog page (as shown in Figure 1). This was something that I had been asking for for quite awhile, so I appreciate that it has been added to SSMS. This simply provides tool support for the backup checksum [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[295],"tags":[391],"class_list":["post-1391","post","type-post","status-publish","format-standard","hentry","category-ssms","tag-ssms-18"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Backup Checksum Feature in SSMS 18.0 Preview 4 - Glenn Berry<\/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\/glenn\/backup-checksum-feature-in-ssms-18-0-preview-4\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Backup Checksum Feature in SSMS 18.0 Preview 4 - Glenn Berry\" \/>\n<meta property=\"og:description\" content=\"I was pleasantly surprised to see a new \u201cBackup checksum\u201d checkbox in the Server Properties, Database Settings dialog page (as shown in Figure 1). This was something that I had been asking for for quite awhile, so I appreciate that it has been added to SSMS. This simply provides tool support for the backup checksum [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/backup-checksum-feature-in-ssms-18-0-preview-4\/\" \/>\n<meta property=\"og:site_name\" content=\"Glenn Berry\" \/>\n<meta property=\"article:published_time\" content=\"2018-09-25T18:07:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2018\/09\/image_thumb.png\" \/>\n<meta name=\"author\" content=\"Glenn Berry\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Glenn Berry\" \/>\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\/glenn\/backup-checksum-feature-in-ssms-18-0-preview-4\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/backup-checksum-feature-in-ssms-18-0-preview-4\/\",\"name\":\"Backup Checksum Feature in SSMS 18.0 Preview 4 - Glenn Berry\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/backup-checksum-feature-in-ssms-18-0-preview-4\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/backup-checksum-feature-in-ssms-18-0-preview-4\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2018\/09\/image_thumb.png\",\"datePublished\":\"2018-09-25T18:07:32+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/backup-checksum-feature-in-ssms-18-0-preview-4\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/backup-checksum-feature-in-ssms-18-0-preview-4\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/backup-checksum-feature-in-ssms-18-0-preview-4\/#primaryimage\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2018\/09\/image_thumb.png\",\"contentUrl\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2018\/09\/image_thumb.png\",\"width\":849,\"height\":772},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/backup-checksum-feature-in-ssms-18-0-preview-4\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Backup Checksum Feature in SSMS 18.0 Preview 4\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\",\"name\":\"Glenn Berry\",\"description\":\"Semi-random musings about SQL Server performance\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/?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\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7\",\"name\":\"Glenn Berry\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g\",\"caption\":\"Glenn Berry\"},\"sameAs\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/author\/glenn\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Backup Checksum Feature in SSMS 18.0 Preview 4 - Glenn Berry","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\/glenn\/backup-checksum-feature-in-ssms-18-0-preview-4\/","og_locale":"en_US","og_type":"article","og_title":"Backup Checksum Feature in SSMS 18.0 Preview 4 - Glenn Berry","og_description":"I was pleasantly surprised to see a new \u201cBackup checksum\u201d checkbox in the Server Properties, Database Settings dialog page (as shown in Figure 1). This was something that I had been asking for for quite awhile, so I appreciate that it has been added to SSMS. This simply provides tool support for the backup checksum [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/backup-checksum-feature-in-ssms-18-0-preview-4\/","og_site_name":"Glenn Berry","article_published_time":"2018-09-25T18:07:32+00:00","og_image":[{"url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2018\/09\/image_thumb.png","type":"","width":"","height":""}],"author":"Glenn Berry","twitter_misc":{"Written by":"Glenn Berry","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/backup-checksum-feature-in-ssms-18-0-preview-4\/","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/backup-checksum-feature-in-ssms-18-0-preview-4\/","name":"Backup Checksum Feature in SSMS 18.0 Preview 4 - Glenn Berry","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/backup-checksum-feature-in-ssms-18-0-preview-4\/#primaryimage"},"image":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/backup-checksum-feature-in-ssms-18-0-preview-4\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2018\/09\/image_thumb.png","datePublished":"2018-09-25T18:07:32+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/backup-checksum-feature-in-ssms-18-0-preview-4\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/glenn\/backup-checksum-feature-in-ssms-18-0-preview-4\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/backup-checksum-feature-in-ssms-18-0-preview-4\/#primaryimage","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2018\/09\/image_thumb.png","contentUrl":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2018\/09\/image_thumb.png","width":849,"height":772},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/backup-checksum-feature-in-ssms-18-0-preview-4\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/glenn\/"},{"@type":"ListItem","position":2,"name":"Backup Checksum Feature in SSMS 18.0 Preview 4"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/","name":"Glenn Berry","description":"Semi-random musings about SQL Server performance","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/glenn\/?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\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7","name":"Glenn Berry","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g","caption":"Glenn Berry"},"sameAs":["https:\/\/www.sqlskills.com\/blogs\/glenn\/"],"url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/author\/glenn\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/1391","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/comments?post=1391"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/1391\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/media?parent=1391"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/categories?post=1391"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/tags?post=1391"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}