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