Getting the backup of all SSRS databases including compressing and encrypting can be straight forward.
However, when planning a complete solution for SQL Server Reporting services backup, following the link below can be more demanding.
Backup and Restore Operations for Reporting Services
Among other things, including the encryption keys, master keys, Backing Up the Configuration Files
Reporting Services uses configuration files to store application settings.
You should back up the files when you first configure the server and after you deploy any custom extensions.
Files to back up include:
- Rsreportserver.config
- Rssrvpolicy.config
- Rsmgrpolicy.config
- Reportingservicesservice.exe.config
- Web.config for the Report Server ASP.NET application
- Machine.config for ASP.NET
QUESTION:
I have just installed SQL Server Reporting Services, migrated all databases and reports, including all folder permissions, from a previous server (sql server 2008),and all is working fine.
However, on the backup strategy, I cannot find some of the .config
files that are required to backup.
The file that is missing is Rsmgrpolicy.config
Why is this file missing?
cls
# PowerShell script to list the DLL files under the system32 folder
$Dir = get-childitem "C:\Program Files\" -recurse
# $Dir |get-member
$List = $Dir | where {$_.extension -eq ".config" -and $_.name -like "*rs*"}
$List | format-table Directory, name