{"id":239,"date":"2016-07-05T10:12:00","date_gmt":"2016-07-05T15:12:00","guid":{"rendered":"http:\/\/www.sqlnuggets.com\/?p=239"},"modified":"2016-07-05T13:50:41","modified_gmt":"2016-07-05T18:50:41","slug":"resolving-write-error-when-backing-up-database-master-key","status":"publish","type":"post","link":"https:\/\/sqlnuggets.com\/resolving-write-error-when-backing-up-database-master-key\/","title":{"rendered":"Resolving Write Error When Backing Up Database Master Key"},"content":{"rendered":"<p>This blog post is more for my own personal notes so that I don&#8217;t bang my head against the wall so much next time, but hopefully it will help someone out one day as well.<\/p>\n<p>I recently set up a new SSISDB Catalog, and needed to back up my Master Key after the catalog was created. This should be a simple and straightforward process, and I haven&#8217;t run into any problems doing this in the past. This time, however, I couldn&#8217;t get the backup to run.<\/p>\n<p>For starters, here is my simple key backup script:<\/p>\n<pre class=\"lang:tsql decode:true\">--back up master key\r\nUSE SSISDB\r\nBACKUP MASTER KEY TO FILE = 'C:\\backup\\key'\r\nENCRYPTION BY PASSWORD = 'YourPasswordHere' --password to encrypt the key backup file<\/pre>\n<p>When running that script, I was immediately greeted with the following error:<\/p>\n<blockquote><p>Cannot write into file &#8216;C :\\backup\\key&#8217;. Verify that you have write permissions, that the file path is valid, and that the file does not already exist.<\/p><\/blockquote>\n<p>My first thought was: The directory path must be wrong. So, I verified that the &#8216;C :\\backup\\key&#8217; directories did exist, and that they were spelled correctly in my script. I tried again and still got the error.<\/p>\n<p>So, maybe the folder permissions are not correct? I check permissions and everything looked good. Just to see, I created new directories and modified my script and tried it again. Still got the error.<\/p>\n<p>After a good bit of Googling and getting nowhere, I took the time to actually read the error I was getting (which, you would think would be one of the first things I did!) As it turns out, the very first line of the error told me exactly with the problem was.<\/p>\n<blockquote><p>Cannot write into <span style=\"color: #ff0000;\">file<\/span> &#8216;C :\\backup\\key&#8217;. Verify that you have write permissions, that the file path is valid, and that the file does not already exist.<\/p><\/blockquote>\n<p>Do you see the problem now? My backup script was trying to create a FILE named &#8220;key&#8221;, but I already had a DIRECTORY named &#8220;key&#8221; in that location. One would think that it could differentiate between the two, and create a file named the same as a directory, but one would be wrong.<\/p>\n<h4>The Solution!<\/h4>\n<p>In this case, the solution was simple, all I had to do was either delete the &#8220;key&#8221; directory, or change the name of the file in my backup script (or change the path to put the file in the &#8220;key&#8221; directory). I chose to delete the directory since it was empty anyway. THAT FIXED IT!<\/p>\n<h4>So, what have we learned today?<\/h4>\n<p>1) Read the dadgum error message, it may actually tell you what&#8217;s wrong!<br \/>\n2) The TO FILE portion of a BACKUP MASTER KEY statement specifies the directory <em>and<\/em> file name of the file being backed up, instead of just the directory path to place the backup file.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This blog post is more for my own personal notes so that I don&#8217;t bang my head against the wall so much next time, but hopefully it will help someone &#8230;<\/p>\n","protected":false},"author":2,"featured_media":0,"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":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[2,23],"tags":[11,33],"class_list":["post-239","post","type-post","status-publish","format-standard","hentry","category-backups","category-ssis","tag-backups","tag-encryption"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Resolving Write Error When Backing Up Database Master Key - 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\/resolving-write-error-when-backing-up-database-master-key\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Resolving Write Error When Backing Up Database Master Key - SQL Nuggets\" \/>\n<meta property=\"og:description\" content=\"This blog post is more for my own personal notes so that I don&#8217;t bang my head against the wall so much next time, but hopefully it will help someone ...\" \/>\n<meta property=\"og:url\" content=\"http:\/\/www.sqlnuggets.com\/resolving-write-error-when-backing-up-database-master-key\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL Nuggets\" \/>\n<meta property=\"article:published_time\" content=\"2016-07-05T15:12:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2016-07-05T18:50:41+00:00\" \/>\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\\\/resolving-write-error-when-backing-up-database-master-key\\\/#article\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/resolving-write-error-when-backing-up-database-master-key\\\/\"},\"author\":{\"name\":\"Eric Cobb\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#\\\/schema\\\/person\\\/210536254addbc1b9d2d95dc1448b38a\"},\"headline\":\"Resolving Write Error When Backing Up Database Master Key\",\"datePublished\":\"2016-07-05T15:12:00+00:00\",\"dateModified\":\"2016-07-05T18:50:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/resolving-write-error-when-backing-up-database-master-key\\\/\"},\"wordCount\":456,\"commentCount\":0,\"publisher\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#organization\"},\"keywords\":[\"Backups\",\"Encryption\"],\"articleSection\":[\"Backups\",\"SSIS\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\\\/\\\/www.sqlnuggets.com\\\/resolving-write-error-when-backing-up-database-master-key\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/resolving-write-error-when-backing-up-database-master-key\\\/\",\"url\":\"http:\\\/\\\/www.sqlnuggets.com\\\/resolving-write-error-when-backing-up-database-master-key\\\/\",\"name\":\"Resolving Write Error When Backing Up Database Master Key - SQL Nuggets\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#website\"},\"datePublished\":\"2016-07-05T15:12:00+00:00\",\"dateModified\":\"2016-07-05T18:50:41+00:00\",\"breadcrumb\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/resolving-write-error-when-backing-up-database-master-key\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\\\/\\\/www.sqlnuggets.com\\\/resolving-write-error-when-backing-up-database-master-key\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/resolving-write-error-when-backing-up-database-master-key\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\\\/\\\/www.sqlnuggets.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Resolving Write Error When Backing Up Database Master Key\"}]},{\"@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":"Resolving Write Error When Backing Up Database Master Key - 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\/resolving-write-error-when-backing-up-database-master-key\/","og_locale":"en_US","og_type":"article","og_title":"Resolving Write Error When Backing Up Database Master Key - SQL Nuggets","og_description":"This blog post is more for my own personal notes so that I don&#8217;t bang my head against the wall so much next time, but hopefully it will help someone ...","og_url":"http:\/\/www.sqlnuggets.com\/resolving-write-error-when-backing-up-database-master-key\/","og_site_name":"SQL Nuggets","article_published_time":"2016-07-05T15:12:00+00:00","article_modified_time":"2016-07-05T18:50:41+00:00","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\/resolving-write-error-when-backing-up-database-master-key\/#article","isPartOf":{"@id":"http:\/\/www.sqlnuggets.com\/resolving-write-error-when-backing-up-database-master-key\/"},"author":{"name":"Eric Cobb","@id":"http:\/\/www.sqlnuggets.com\/#\/schema\/person\/210536254addbc1b9d2d95dc1448b38a"},"headline":"Resolving Write Error When Backing Up Database Master Key","datePublished":"2016-07-05T15:12:00+00:00","dateModified":"2016-07-05T18:50:41+00:00","mainEntityOfPage":{"@id":"http:\/\/www.sqlnuggets.com\/resolving-write-error-when-backing-up-database-master-key\/"},"wordCount":456,"commentCount":0,"publisher":{"@id":"http:\/\/www.sqlnuggets.com\/#organization"},"keywords":["Backups","Encryption"],"articleSection":["Backups","SSIS"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["http:\/\/www.sqlnuggets.com\/resolving-write-error-when-backing-up-database-master-key\/#respond"]}]},{"@type":"WebPage","@id":"http:\/\/www.sqlnuggets.com\/resolving-write-error-when-backing-up-database-master-key\/","url":"http:\/\/www.sqlnuggets.com\/resolving-write-error-when-backing-up-database-master-key\/","name":"Resolving Write Error When Backing Up Database Master Key - SQL Nuggets","isPartOf":{"@id":"http:\/\/www.sqlnuggets.com\/#website"},"datePublished":"2016-07-05T15:12:00+00:00","dateModified":"2016-07-05T18:50:41+00:00","breadcrumb":{"@id":"http:\/\/www.sqlnuggets.com\/resolving-write-error-when-backing-up-database-master-key\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/www.sqlnuggets.com\/resolving-write-error-when-backing-up-database-master-key\/"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/www.sqlnuggets.com\/resolving-write-error-when-backing-up-database-master-key\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/www.sqlnuggets.com\/"},{"@type":"ListItem","position":2,"name":"Resolving Write Error When Backing Up Database Master Key"}]},{"@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":"","jetpack_shortlink":"https:\/\/wp.me\/pdyDvE-3R","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":239,"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":1615,"url":"https:\/\/sqlnuggets.com\/yikes-cannot-recover-the-master-database\/","url_meta":{"origin":239,"position":1},"title":"Yikes!  Cannot recover the master database!","author":"Eric Cobb","date":"May 11, 2021","format":false,"excerpt":"Recently, during patching for a 2019 SQL Server, the SQL services refused to start after the patching. It was throwing the following heart attack inducing error: Cannot recover the master database. SQL Server is unable to run. Restore master from a full backup, repair it, or rebuild it. This is\u2026","rel":"","context":"In &quot;Corruption&quot;","block_context":{"text":"Corruption","link":"https:\/\/sqlnuggets.com\/category\/corruption\/"},"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":591,"url":"https:\/\/sqlnuggets.com\/sql-scripts-make-sure-backup-valid\/","url_meta":{"origin":239,"position":2},"title":"SQL Scripts: How To Make Sure Your Backup Is Valid","author":"Eric Cobb","date":"November 1, 2017","format":false,"excerpt":"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\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":690,"url":"https:\/\/sqlnuggets.com\/corruption-backup-compression-tde-sql-2017\/","url_meta":{"origin":239,"position":3},"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":1158,"url":"https:\/\/sqlnuggets.com\/backing-up-databases-with-the-dbatools-powershell-module\/","url_meta":{"origin":239,"position":4},"title":"Backing Up Databases With The dbatools PowerShell Module","author":"Eric Cobb","date":"November 20, 2019","format":false,"excerpt":"We do a lot of database backups and restores at work, outside of our regular backup routines. A lot! I've actually done as many as 40 in one day. Our \"enterprise\" backup system is too cumbersome to try to use like this, so we needed something that would allow us\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\/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":[]},{"id":600,"url":"https:\/\/sqlnuggets.com\/notes-sql-2017-azure-install-using-group-managed-service-accounts\/","url_meta":{"origin":239,"position":5},"title":"Notes From A SQL 2017 Azure Install &#8211; Using Group Managed Service Accounts","author":"Eric Cobb","date":"November 7, 2017","format":false,"excerpt":"One of the new features that I'm excited about implementing on my Windows 2016 SQL Server 2017 servers is the ability to use\u00a0Group Managed Service Accounts, or \"gMSA\" for short.\u00a0 This isn't really a new feature, I believe it was first made available for SQL Server 2014 running on Windows\u2026","rel":"","context":"In &quot;Availability Groups&quot;","block_context":{"text":"Availability Groups","link":"https:\/\/sqlnuggets.com\/category\/availability-groups\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/10\/Cloud-Azure.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/10\/Cloud-Azure.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/10\/Cloud-Azure.jpg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/10\/Cloud-Azure.jpg?resize=700%2C400&ssl=1 2x"},"classes":[]}],"_links":{"self":[{"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/posts\/239","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=239"}],"version-history":[{"count":0,"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/posts\/239\/revisions"}],"wp:attachment":[{"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/media?parent=239"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/categories?post=239"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/tags?post=239"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}