{"id":591,"date":"2017-11-01T09:59:28","date_gmt":"2017-11-01T14:59:28","guid":{"rendered":"http:\/\/www.sqlnuggets.com\/?p=591"},"modified":"2018-01-16T14:07:52","modified_gmt":"2018-01-16T20:07:52","slug":"sql-scripts-make-sure-backup-valid","status":"publish","type":"post","link":"https:\/\/sqlnuggets.com\/sql-scripts-make-sure-backup-valid\/","title":{"rendered":"SQL Scripts: How To Make Sure Your Backup Is Valid"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" class=\"alignright size-large wp-image-594\" src=\"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2017\/11\/corrupt-147974_1280-1024x512.png\" alt=\"\" width=\"800\" height=\"400\" srcset=\"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2017\/11\/corrupt-147974_1280-1024x512.png 1024w, https:\/\/sqlnuggets.com\/wp-content\/uploads\/2017\/11\/corrupt-147974_1280-300x150.png 300w, https:\/\/sqlnuggets.com\/wp-content\/uploads\/2017\/11\/corrupt-147974_1280-768x384.png 768w, https:\/\/sqlnuggets.com\/wp-content\/uploads\/2017\/11\/corrupt-147974_1280.png 1280w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/>I recently had a case where I needed to download a database backup to my laptop.\u00a0 It usually takes about 12 hours for this particular backup to copy down, so I started it at the end of the day to let it run over night.\u00a0 Unfortunately, when I sat down to start work the next day I discovered that my laptop was turned off.\u00a0 Sometime during the night it had gotten OS updates and then shut down.<\/p>\n<p>Once I got my laptop up I checked to see if my backup download completed before the laptop shut down.\u00a0 I saw that the backup had been downloaded, and the file was the full size of what I would expect.\u00a0 However the paranoid DBA in me does not trust this, so I ran a quick\u00a0<a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/statements\/restore-statements-verifyonly-transact-sql\" target=\"_blank\" rel=\"noopener\">RESTORE VERIFYONLY<\/a> check to see if the backup was indeed valid.\u00a0 This check is a simple one line of code:<\/p>\n<pre class=\"lang:tsql decode:true \">RESTORE VERIFYONLY FROM DISK = 'C:\\backups\\MyDB.bak';<\/pre>\n<p>This command\u00a0does not restore the backup, it just checks to see if the backup is complete and that the entire backup is readable.\u00a0 RESTORE VERIFYONLY is very useful, and very important to run.\u00a0 I run this command as part of my regular backup routines (it&#8217;s built in to the <a href=\"https:\/\/sqlnuggets.com\/blog\/sql-server-maintenance-scripts\/\">maintenance solution<\/a> that I use).<\/p>\n<p>Running\u00a0RESTORE VERIFYONLY produced the following output, which confirmed what I suspected:<\/p>\n<h5><span style=\"color: #ff0000;\">The file on device &#8216;C:\\backups\\MyDB.bak&#8217; is not a valid Microsoft Tape Format backup set.<\/span><\/h5>\n<p>My backup was not valid.\u00a0 Running RESTORE VERIFYONLY on the original backup on the server showed that it was fine, so my laptop must have shut down before my backup download completed, corrupting the file.<\/p>\n<p>In my particular case the fix was easy, I just downloaded the backup again (and ensured my laptop stayed on this time!)<\/p>\n<p>A positive result from RESTORE VERIFYONLY does not mean check your database for corruption, and it does not attempt to verify the structure of your data.\u00a0 Even if RESTORE VERIFYONLY says your backup is good, in order to know if your backup (and database) is truly valid you need to restore it.\u00a0 If I were to attempt to restore my bad database backup, I would have seen the following error:<\/p>\n<h5><span style=\"color: #ff0000;\">The file ID 1 on device &#8216;C:\\BACKUPS\\MYDB.BAK&#8217; is incorrectly formed and can not be read.<br \/>\nRESTORE DATABASE is terminating abnormally.<\/span><\/h5>\n<p>&nbsp;<\/p>\n<p><em>This post is part of an ongoing\u00a0<a href=\"https:\/\/sqlnuggets.com\/blog\/category\/sql-scripts\/\">SQL Scripts<\/a>\u00a0series, in which I list useful queries that I use in my day to day database administration.<\/em><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I recently had a case where I needed to download a database backup to my laptop.\u00a0 It usually takes about 12 hours for this particular backup to copy down, so &#8230;<\/p>\n","protected":false},"author":2,"featured_media":594,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[2,62,49,52],"tags":[11],"class_list":["post-591","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-backups","category-corruption","category-errors","category-sql-scripts","tag-backups"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL Scripts: How To Make Sure Your Backup Is Valid - SQL Nuggets<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/www.sqlnuggets.com\/sql-scripts-make-sure-backup-valid\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Scripts: How To Make Sure Your Backup Is Valid - SQL Nuggets\" \/>\n<meta property=\"og:description\" content=\"I recently had a case where I needed to download a database backup to my laptop.\u00a0 It usually takes about 12 hours for this particular backup to copy down, so ...\" \/>\n<meta property=\"og:url\" content=\"http:\/\/www.sqlnuggets.com\/sql-scripts-make-sure-backup-valid\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL Nuggets\" \/>\n<meta property=\"article:published_time\" content=\"2017-11-01T14:59:28+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-01-16T20:07:52+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.sqlnuggets.com\/wp-content\/uploads\/2017\/11\/corrupt-147974_1280.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"640\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Eric Cobb\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@cfgears\" \/>\n<meta name=\"twitter:site\" content=\"@sqlnugg\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Eric Cobb\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/sql-scripts-make-sure-backup-valid\\\/#article\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/sql-scripts-make-sure-backup-valid\\\/\"},\"author\":{\"name\":\"Eric Cobb\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#\\\/schema\\\/person\\\/210536254addbc1b9d2d95dc1448b38a\"},\"headline\":\"SQL Scripts: How To Make Sure Your Backup Is Valid\",\"datePublished\":\"2017-11-01T14:59:28+00:00\",\"dateModified\":\"2018-01-16T20:07:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/sql-scripts-make-sure-backup-valid\\\/\"},\"wordCount\":422,\"commentCount\":0,\"publisher\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#organization\"},\"image\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/sql-scripts-make-sure-backup-valid\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sqlnuggets.com\\\/wp-content\\\/uploads\\\/2017\\\/11\\\/corrupt-147974_1280.png\",\"keywords\":[\"Backups\"],\"articleSection\":[\"Backups\",\"Corruption\",\"Errors\",\"SQL Scripts\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\\\/\\\/www.sqlnuggets.com\\\/sql-scripts-make-sure-backup-valid\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/sql-scripts-make-sure-backup-valid\\\/\",\"url\":\"http:\\\/\\\/www.sqlnuggets.com\\\/sql-scripts-make-sure-backup-valid\\\/\",\"name\":\"SQL Scripts: How To Make Sure Your Backup Is Valid - SQL Nuggets\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/sql-scripts-make-sure-backup-valid\\\/#primaryimage\"},\"image\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/sql-scripts-make-sure-backup-valid\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sqlnuggets.com\\\/wp-content\\\/uploads\\\/2017\\\/11\\\/corrupt-147974_1280.png\",\"datePublished\":\"2017-11-01T14:59:28+00:00\",\"dateModified\":\"2018-01-16T20:07:52+00:00\",\"breadcrumb\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/sql-scripts-make-sure-backup-valid\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\\\/\\\/www.sqlnuggets.com\\\/sql-scripts-make-sure-backup-valid\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/sql-scripts-make-sure-backup-valid\\\/#primaryimage\",\"url\":\"https:\\\/\\\/sqlnuggets.com\\\/wp-content\\\/uploads\\\/2017\\\/11\\\/corrupt-147974_1280.png\",\"contentUrl\":\"https:\\\/\\\/sqlnuggets.com\\\/wp-content\\\/uploads\\\/2017\\\/11\\\/corrupt-147974_1280.png\",\"width\":1280,\"height\":640},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/sql-scripts-make-sure-backup-valid\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\\\/\\\/www.sqlnuggets.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Scripts: How To Make Sure Your Backup Is Valid\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#website\",\"url\":\"http:\\\/\\\/www.sqlnuggets.com\\\/\",\"name\":\"SQL Nuggets\",\"description\":\"Nuggets Of SQL Server Knowledge\",\"publisher\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\\\/\\\/www.sqlnuggets.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#organization\",\"name\":\"SQL Nuggets\",\"url\":\"http:\\\/\\\/www.sqlnuggets.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/sqlnuggets.com\\\/wp-content\\\/uploads\\\/2023\\\/11\\\/website-logo.jpg\",\"contentUrl\":\"https:\\\/\\\/sqlnuggets.com\\\/wp-content\\\/uploads\\\/2023\\\/11\\\/website-logo.jpg\",\"width\":320,\"height\":54,\"caption\":\"SQL Nuggets\"},\"image\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/x.com\\\/sqlnugg\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/ericcobb\\\/\"]},{\"@type\":\"Person\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#\\\/schema\\\/person\\\/210536254addbc1b9d2d95dc1448b38a\",\"name\":\"Eric Cobb\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3ca1fc0c7054a668e048f09d412cd4ebf89833c4630fbbfccca78a0678a6bdc2?s=96&d=mm&r=pg\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3ca1fc0c7054a668e048f09d412cd4ebf89833c4630fbbfccca78a0678a6bdc2?s=96&d=mm&r=pg\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3ca1fc0c7054a668e048f09d412cd4ebf89833c4630fbbfccca78a0678a6bdc2?s=96&d=mm&r=pg\",\"caption\":\"Eric Cobb\"},\"sameAs\":[\"https:\\\/\\\/x.com\\\/cfgears\"],\"url\":\"https:\\\/\\\/sqlnuggets.com\\\/author\\\/eric-cobb\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Scripts: How To Make Sure Your Backup Is Valid - SQL Nuggets","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":"http:\/\/www.sqlnuggets.com\/sql-scripts-make-sure-backup-valid\/","og_locale":"en_US","og_type":"article","og_title":"SQL Scripts: How To Make Sure Your Backup Is Valid - SQL Nuggets","og_description":"I recently had a case where I needed to download a database backup to my laptop.\u00a0 It usually takes about 12 hours for this particular backup to copy down, so ...","og_url":"http:\/\/www.sqlnuggets.com\/sql-scripts-make-sure-backup-valid\/","og_site_name":"SQL Nuggets","article_published_time":"2017-11-01T14:59:28+00:00","article_modified_time":"2018-01-16T20:07:52+00:00","og_image":[{"width":1280,"height":640,"url":"http:\/\/www.sqlnuggets.com\/wp-content\/uploads\/2017\/11\/corrupt-147974_1280.png","type":"image\/png"}],"author":"Eric Cobb","twitter_card":"summary_large_image","twitter_creator":"@cfgears","twitter_site":"@sqlnugg","twitter_misc":{"Written by":"Eric Cobb","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/www.sqlnuggets.com\/sql-scripts-make-sure-backup-valid\/#article","isPartOf":{"@id":"http:\/\/www.sqlnuggets.com\/sql-scripts-make-sure-backup-valid\/"},"author":{"name":"Eric Cobb","@id":"http:\/\/www.sqlnuggets.com\/#\/schema\/person\/210536254addbc1b9d2d95dc1448b38a"},"headline":"SQL Scripts: How To Make Sure Your Backup Is Valid","datePublished":"2017-11-01T14:59:28+00:00","dateModified":"2018-01-16T20:07:52+00:00","mainEntityOfPage":{"@id":"http:\/\/www.sqlnuggets.com\/sql-scripts-make-sure-backup-valid\/"},"wordCount":422,"commentCount":0,"publisher":{"@id":"http:\/\/www.sqlnuggets.com\/#organization"},"image":{"@id":"http:\/\/www.sqlnuggets.com\/sql-scripts-make-sure-backup-valid\/#primaryimage"},"thumbnailUrl":"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2017\/11\/corrupt-147974_1280.png","keywords":["Backups"],"articleSection":["Backups","Corruption","Errors","SQL Scripts"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["http:\/\/www.sqlnuggets.com\/sql-scripts-make-sure-backup-valid\/#respond"]}]},{"@type":"WebPage","@id":"http:\/\/www.sqlnuggets.com\/sql-scripts-make-sure-backup-valid\/","url":"http:\/\/www.sqlnuggets.com\/sql-scripts-make-sure-backup-valid\/","name":"SQL Scripts: How To Make Sure Your Backup Is Valid - SQL Nuggets","isPartOf":{"@id":"http:\/\/www.sqlnuggets.com\/#website"},"primaryImageOfPage":{"@id":"http:\/\/www.sqlnuggets.com\/sql-scripts-make-sure-backup-valid\/#primaryimage"},"image":{"@id":"http:\/\/www.sqlnuggets.com\/sql-scripts-make-sure-backup-valid\/#primaryimage"},"thumbnailUrl":"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2017\/11\/corrupt-147974_1280.png","datePublished":"2017-11-01T14:59:28+00:00","dateModified":"2018-01-16T20:07:52+00:00","breadcrumb":{"@id":"http:\/\/www.sqlnuggets.com\/sql-scripts-make-sure-backup-valid\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/www.sqlnuggets.com\/sql-scripts-make-sure-backup-valid\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/www.sqlnuggets.com\/sql-scripts-make-sure-backup-valid\/#primaryimage","url":"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2017\/11\/corrupt-147974_1280.png","contentUrl":"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2017\/11\/corrupt-147974_1280.png","width":1280,"height":640},{"@type":"BreadcrumbList","@id":"http:\/\/www.sqlnuggets.com\/sql-scripts-make-sure-backup-valid\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/www.sqlnuggets.com\/"},{"@type":"ListItem","position":2,"name":"SQL Scripts: How To Make Sure Your Backup Is Valid"}]},{"@type":"WebSite","@id":"http:\/\/www.sqlnuggets.com\/#website","url":"http:\/\/www.sqlnuggets.com\/","name":"SQL Nuggets","description":"Nuggets Of SQL Server Knowledge","publisher":{"@id":"http:\/\/www.sqlnuggets.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/www.sqlnuggets.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"http:\/\/www.sqlnuggets.com\/#organization","name":"SQL Nuggets","url":"http:\/\/www.sqlnuggets.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/www.sqlnuggets.com\/#\/schema\/logo\/image\/","url":"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2023\/11\/website-logo.jpg","contentUrl":"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2023\/11\/website-logo.jpg","width":320,"height":54,"caption":"SQL Nuggets"},"image":{"@id":"http:\/\/www.sqlnuggets.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/sqlnugg","https:\/\/www.linkedin.com\/in\/ericcobb\/"]},{"@type":"Person","@id":"http:\/\/www.sqlnuggets.com\/#\/schema\/person\/210536254addbc1b9d2d95dc1448b38a","name":"Eric Cobb","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/3ca1fc0c7054a668e048f09d412cd4ebf89833c4630fbbfccca78a0678a6bdc2?s=96&d=mm&r=pg","url":"https:\/\/secure.gravatar.com\/avatar\/3ca1fc0c7054a668e048f09d412cd4ebf89833c4630fbbfccca78a0678a6bdc2?s=96&d=mm&r=pg","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3ca1fc0c7054a668e048f09d412cd4ebf89833c4630fbbfccca78a0678a6bdc2?s=96&d=mm&r=pg","caption":"Eric Cobb"},"sameAs":["https:\/\/x.com\/cfgears"],"url":"https:\/\/sqlnuggets.com\/author\/eric-cobb\/"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2017\/11\/corrupt-147974_1280.png","jetpack_shortlink":"https:\/\/wp.me\/pdyDvE-9x","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":27,"url":"https:\/\/sqlnuggets.com\/automating-backups-for-sql-server-2008-r2-express-edition\/","url_meta":{"origin":591,"position":0},"title":"Automating backups for SQL Server 2008 R2 Express Edition","author":"Eric Cobb","date":"June 9, 2015","format":false,"excerpt":"One of the limitations of SQL Server Express is that you can't automate backups in it via the SQL Server Agent like you can the other versions of SQL Server. You have to manually write the backup scripts and then schedule them to run in Windows Scheduled Tasks. This really\u2026","rel":"","context":"In &quot;Backups&quot;","block_context":{"text":"Backups","link":"https:\/\/sqlnuggets.com\/category\/backups\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":690,"url":"https:\/\/sqlnuggets.com\/corruption-backup-compression-tde-sql-2017\/","url_meta":{"origin":591,"position":1},"title":"Corruption With Backup Compression And TDE In SQL 2017","author":"Eric Cobb","date":"January 16, 2018","format":false,"excerpt":"Last week I spent a good bit of time dealing with a corruption issue, and as it turns out I may actually have found a bug in SQL Server 2017.\u00a0 I say \"may\" because even though I have been working a Microsoft SQL Server PFE (Premier Field Engineer) and providing\u2026","rel":"","context":"In &quot;Backups&quot;","block_context":{"text":"Backups","link":"https:\/\/sqlnuggets.com\/category\/backups\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/11\/corrupt-147974_1280.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/11\/corrupt-147974_1280.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/11\/corrupt-147974_1280.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/11\/corrupt-147974_1280.png?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/11\/corrupt-147974_1280.png?resize=1050%2C600&ssl=1 3x"},"classes":[]},{"id":93,"url":"https:\/\/sqlnuggets.com\/sql-server-maintenance-scripts\/","url_meta":{"origin":591,"position":2},"title":"SQL Server Maintenance Scripts","author":"Eric Cobb","date":"July 9, 2015","format":false,"excerpt":"When it comes to everyday routine maintenance of your SQL Server databases, you can't beat Ola Hallengren's\u00a0SQL Server Maintenance Solution. \u00a0Focusing on\u00a0SQL Server Backups,\u00a0SQL Server Integrity Checks, and SQL Server Index and Statistics Maintenance, it\u00a0has pretty much become the go-to\u00a0maintenance solution for many SQL Server database administrators. \u00a0We have it\u2026","rel":"","context":"In &quot;Tools&quot;","block_context":{"text":"Tools","link":"https:\/\/sqlnuggets.com\/category\/tools\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":239,"url":"https:\/\/sqlnuggets.com\/resolving-write-error-when-backing-up-database-master-key\/","url_meta":{"origin":591,"position":3},"title":"Resolving Write Error When Backing Up Database Master Key","author":"Eric Cobb","date":"July 5, 2016","format":false,"excerpt":"This blog post is more for my own personal notes so that I don't bang my head against the wall so much next time, but hopefully it will help someone out one day as well. I recently set up a new SSISDB Catalog, and needed to back up my Master\u2026","rel":"","context":"In &quot;Backups&quot;","block_context":{"text":"Backups","link":"https:\/\/sqlnuggets.com\/category\/backups\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":214,"url":"https:\/\/sqlnuggets.com\/what-features-are-disabled-between-compatibility-levels-in-sql-server\/","url_meta":{"origin":591,"position":4},"title":"What Features Are Disabled Between Compatibility Levels In SQL Server?","author":"Eric Cobb","date":"March 16, 2016","format":false,"excerpt":"Have you ever wondered what features may or may not be available when your database is running in a different compatibility level than your SQL Server version? I recently came across a situation where a database was on SQL Server 2014 (compatibility level 120), but the database compatibility level was\u2026","rel":"","context":"In &quot;DB Engine&quot;","block_context":{"text":"DB Engine","link":"https:\/\/sqlnuggets.com\/category\/db-engine\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":887,"url":"https:\/\/sqlnuggets.com\/using-dbatools-powershell-module-to-configure-sql-server\/","url_meta":{"origin":591,"position":5},"title":"Using dbatools PowerShell Module To Configure SQL Server","author":"Eric Cobb","date":"October 9, 2018","format":false,"excerpt":"The more I use\u00a0the\u00a0dbatools PowerShell module, the more I like it.\u00a0 It really is a solid set of scripts that allow you to easily manage your SQL Servers via PowerShell.\u00a0 If you are not familiar with dbatools, I recommend you head over to my previous post,\u00a0Getting Started With The dbatools\u2026","rel":"","context":"In &quot;PowerShell&quot;","block_context":{"text":"PowerShell","link":"https:\/\/sqlnuggets.com\/category\/powershell\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2018\/07\/powershell4.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2018\/07\/powershell4.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2018\/07\/powershell4.png?resize=525%2C300&ssl=1 1.5x"},"classes":[]}],"_links":{"self":[{"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/posts\/591","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/comments?post=591"}],"version-history":[{"count":0,"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/posts\/591\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/media\/594"}],"wp:attachment":[{"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/media?parent=591"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/categories?post=591"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/tags?post=591"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}