{"id":1721,"date":"2019-03-21T10:58:19","date_gmt":"2019-03-21T14:58:19","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/jonathan\/?p=1721"},"modified":"2019-03-21T13:39:39","modified_gmt":"2019-03-21T17:39:39","slug":"backup-your-reporting-services-encryption-key","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/backup-your-reporting-services-encryption-key\/","title":{"rendered":"Backup your Reporting Services Encryption Key"},"content":{"rendered":"<p>If you run SQL Server Reporting Services, part of your DR plan needs to include a backup of the encryption key for SSRS.  This sadly is an all to often overlooked part of the solution, even though it is incredibly easy to do. If you don&#8217;t have a backup of the encryption key during a restore, the report server will never be able to decrypt the encrypted content (connection strings, passwords, etc) stored in the database, and your only recourse would be to delete the encrypted content and recreate it manually or through a redeployment of datasources. <\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/install-windows\/ssrs-encryption-keys-back-up-and-restore-encryption-keys?view=sql-server-2017\" rel=\"noopener\" target=\"_blank\">https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/install-windows\/ssrs-encryption-keys-back-up-and-restore-encryption-keys?view=sql-server-2017<\/a><\/p>\n<p>For those that are into Powershell, Microsoft has provided a simple function Backup-RsEncryptionKey that can be utilized for this as well:<\/p>\n<p><a href=\"https:\/\/www.powershellgallery.com\/packages\/ReportingServicesTools\/0.0.0.2\/Content\/Functions%5CAdmin%5CBackup-RsEncryptionKey.ps1\" rel=\"noopener\" target=\"_blank\">https:\/\/www.powershellgallery.com\/packages\/ReportingServicesTools\/0.0.0.2\/Content\/Functions%5CAdmin%5CBackup-RsEncryptionKey.ps1<\/a><\/p>\n<p>Make sure that you&#8217;ve covered all your bases with backups of other keys and certificates as well.  Even if you think you&#8217;ve got your bases covered, now is a great time to verify, especially for anyone using Transparent Data Encryption for a database. One of the worst emails we&#8217;ve ever gotten from someone in the community was that they had backups of their database but not the certificate used for encryption and they couldn&#8217;t restore the database or access the data, and there is absolutely nothing anybody can do to help you if this happens.  <\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you run SQL Server Reporting Services, part of your DR plan needs to include a backup of the encryption key for SSRS. This sadly is an all to often overlooked part of the solution, even though it is incredibly easy to do. If you don&#8217;t have a backup of the encryption key during a [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[54],"tags":[],"class_list":["post-1721","post","type-post","status-publish","format-standard","hentry","category-backup"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Backup your Reporting Services Encryption Key - Jonathan Kehayias<\/title>\n<meta name=\"description\" content=\"Performing a backup of your SSRS Encryption Key is an essential part of your total backup solution for SQL Server. Learn how in this post.\" \/>\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\/jonathan\/backup-your-reporting-services-encryption-key\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Backup your Reporting Services Encryption Key - Jonathan Kehayias\" \/>\n<meta property=\"og:description\" content=\"Performing a backup of your SSRS Encryption Key is an essential part of your total backup solution for SQL Server. Learn how in this post.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/backup-your-reporting-services-encryption-key\/\" \/>\n<meta property=\"og:site_name\" content=\"Jonathan Kehayias\" \/>\n<meta property=\"article:published_time\" content=\"2019-03-21T14:58:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-03-21T17:39:39+00:00\" \/>\n<meta name=\"author\" content=\"Jonathan Kehayias\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jonathan Kehayias\" \/>\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\":\"Article\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/backup-your-reporting-services-encryption-key\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/backup-your-reporting-services-encryption-key\\\/\"},\"author\":{\"name\":\"Jonathan Kehayias\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#\\\/schema\\\/person\\\/01c10d94f3648654ef706d5e6305f69c\"},\"headline\":\"Backup your Reporting Services Encryption Key\",\"datePublished\":\"2019-03-21T14:58:19+00:00\",\"dateModified\":\"2019-03-21T17:39:39+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/backup-your-reporting-services-encryption-key\\\/\"},\"wordCount\":246,\"commentCount\":0,\"articleSection\":[\"Backup\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/backup-your-reporting-services-encryption-key\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/backup-your-reporting-services-encryption-key\\\/\",\"url\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/backup-your-reporting-services-encryption-key\\\/\",\"name\":\"Backup your Reporting Services Encryption Key - Jonathan Kehayias\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#website\"},\"datePublished\":\"2019-03-21T14:58:19+00:00\",\"dateModified\":\"2019-03-21T17:39:39+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#\\\/schema\\\/person\\\/01c10d94f3648654ef706d5e6305f69c\"},\"description\":\"Performing a backup of your SSRS Encryption Key is an essential part of your total backup solution for SQL Server. Learn how in this post.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/backup-your-reporting-services-encryption-key\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/backup-your-reporting-services-encryption-key\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/backup-your-reporting-services-encryption-key\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Backup\",\"item\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/category\\\/backup\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Backup your Reporting Services Encryption Key\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#website\",\"url\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/\",\"name\":\"Jonathan Kehayias - The Rambling DBA\",\"description\":\"The Rambling DBA\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/?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\\\/jonathan\\\/#\\\/schema\\\/person\\\/01c10d94f3648654ef706d5e6305f69c\",\"name\":\"Jonathan Kehayias\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g\",\"caption\":\"Jonathan Kehayias\"},\"sameAs\":[\"http:\\\/\\\/3.209.169.194\\\/blogs\\\/jonathan\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Backup your Reporting Services Encryption Key - Jonathan Kehayias","description":"Performing a backup of your SSRS Encryption Key is an essential part of your total backup solution for SQL Server. Learn how in this post.","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\/jonathan\/backup-your-reporting-services-encryption-key\/","og_locale":"en_US","og_type":"article","og_title":"Backup your Reporting Services Encryption Key - Jonathan Kehayias","og_description":"Performing a backup of your SSRS Encryption Key is an essential part of your total backup solution for SQL Server. Learn how in this post.","og_url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/backup-your-reporting-services-encryption-key\/","og_site_name":"Jonathan Kehayias","article_published_time":"2019-03-21T14:58:19+00:00","article_modified_time":"2019-03-21T17:39:39+00:00","author":"Jonathan Kehayias","twitter_misc":{"Written by":"Jonathan Kehayias","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/backup-your-reporting-services-encryption-key\/#article","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/backup-your-reporting-services-encryption-key\/"},"author":{"name":"Jonathan Kehayias","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#\/schema\/person\/01c10d94f3648654ef706d5e6305f69c"},"headline":"Backup your Reporting Services Encryption Key","datePublished":"2019-03-21T14:58:19+00:00","dateModified":"2019-03-21T17:39:39+00:00","mainEntityOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/backup-your-reporting-services-encryption-key\/"},"wordCount":246,"commentCount":0,"articleSection":["Backup"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.sqlskills.com\/blogs\/jonathan\/backup-your-reporting-services-encryption-key\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/backup-your-reporting-services-encryption-key\/","url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/backup-your-reporting-services-encryption-key\/","name":"Backup your Reporting Services Encryption Key - Jonathan Kehayias","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#website"},"datePublished":"2019-03-21T14:58:19+00:00","dateModified":"2019-03-21T17:39:39+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#\/schema\/person\/01c10d94f3648654ef706d5e6305f69c"},"description":"Performing a backup of your SSRS Encryption Key is an essential part of your total backup solution for SQL Server. Learn how in this post.","breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/backup-your-reporting-services-encryption-key\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/jonathan\/backup-your-reporting-services-encryption-key\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/backup-your-reporting-services-encryption-key\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/"},{"@type":"ListItem","position":2,"name":"Backup","item":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/category\/backup\/"},{"@type":"ListItem","position":3,"name":"Backup your Reporting Services Encryption Key"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/","name":"Jonathan Kehayias - The Rambling DBA","description":"The Rambling DBA","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/?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\/jonathan\/#\/schema\/person\/01c10d94f3648654ef706d5e6305f69c","name":"Jonathan Kehayias","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g","caption":"Jonathan Kehayias"},"sameAs":["http:\/\/3.209.169.194\/blogs\/jonathan"]}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/posts\/1721","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/comments?post=1721"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/posts\/1721\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/media?parent=1721"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/categories?post=1721"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/tags?post=1721"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}