Report server encryption key is essential in recovering, migrating and troubleshooting. Although, we generally backup it when report server is built, but it is required to take backup time-to-time to avoid any miss-out. Scheduling a SQL Server job on the SQL Server will be sufficient and we can schedule it to run once a week.
Below is a simple Powershell script which can help you scheduling such a job :
You can schedule the job with Powershell subsystem or CMDExec subsystem depending on the standard followed in your organization.
Thanks for reading this article! Please do update me if you have issues running it.
Below is a simple Powershell script which can help you scheduling such a job :
You can schedule the job with Powershell subsystem or CMDExec subsystem depending on the standard followed in your organization.
Thanks for reading this article! Please do update me if you have issues running it.
This is awesome. i have been looking for something like this.
ReplyDeleteI am getting error. any idea how to resolve
ReplyDeleteFailure : The term 'RSKeyMgmt.exe' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path