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.
No comments:
Post a Comment