August 17, 2017 at 1:24 pm
Hi Experts,
Could you please let me know if there is a way to find out the SSRS Encryption Key backup location.
Is there any table/registry key which keeps this information?
Thanks in advance,
Dev
August 18, 2017 at 3:31 am
dev.tridib - Thursday, August 17, 2017 1:24 PMHi Experts,
Could you please let me know if there is a way to find out the SSRS Encryption Key backup location.
Is there any table/registry key which keeps this information?Thanks in advance,
Dev
I'm playing a bit of recollection here, but don't you create the encryption key back up in the Reporting Services Configuration Manager? I think there's a keys pane. When create a back up it asks where you want to back up the file, so you can save it where you want to. SSRS doesn't create a backup "automagically" is a "secure place". If you don't create a backup and keep it somewhere safe, then it's gone. Much like if you create a database and don't back it up; if you DROP it, or it corrupts, the data is lost.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 18, 2017 at 11:27 am
Thom A - Friday, August 18, 2017 3:31 AMdev.tridib - Thursday, August 17, 2017 1:24 PMHi Experts,
Could you please let me know if there is a way to find out the SSRS Encryption Key backup location.
Is there any table/registry key which keeps this information?Thanks in advance,
DevI'm playing a bit of recollection here, but don't you create the encryption key back up in the Reporting Services Configuration Manager? I think there's a keys pane. When create a back up it asks where you want to back up the file, so you can save it where you want to. SSRS doesn't create a backup "automagically" is a "secure place". If you don't create a backup and keep it somewhere safe, then it's gone. Much like if you create a database and don't back it up; if you DROP it, or it corrupts, the data is lost.
Thanks for your reply. I completely understand the necessity of backing up encryption key. Let me rephrase my question.
Is there any way I can check using script (Power shell/T-SQL) that the key backup was successful and the date of backup. Just the way we can check in msdb..backupset about database backup. My customer wants a report to be sent mentioning the Key backup date and that's why I am looking for metadata table from where I can get the location of the backup so that I can provide a generic script.
August 21, 2017 at 1:15 am
dev.tridib - Friday, August 18, 2017 11:27 AMThanks for your reply. I completely understand the necessity of backing up encryption key. Let me rephrase my question.
Is there any way I can check using script (Power shell/T-SQL) that the key backup was successful and the date of backup. Just the way we can check in msdb..backupset about database backup. My customer wants a report to be sent mentioning the Key backup date and that's why I am looking for metadata table from where I can get the location of the backup so that I can provide a generic script.
No. Unlike a SQL Server Database back up, you only ever need "one" backup of the key, provided you keep it safe. It won't change like a database does (which is part of the reason why SQL Server keeps a history, so you know how old your backups are).
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy