A recent post on the MVP alias got me thinking that others may not know that the standard ConfigMgr 2007 backup task does not back up the SSRS reports. If you have not extended the SSRS reports in any way, then the default SSRS reports can easily be recreated. Simply create a new Site Reporting Services Role.
However, if you have created any custom reports, report models, etc you will need to follow these guidelines.
Here's what you need to know:
Backup your SSRS installation and reports
1) Backup the report server databases - all application data is stored in the reportserver and reportservertempdb databases. Use the standard SQL Server backup task.
2) Backup the Encryption Keys
3) Backup the Configuration files
Reporting Services uses configuration files to store application settings. You should backup the files when you first configure the server and after you deploy any custom extensions. Files to back up include:
- Rsreportserver.config
- Rssvrpolicy.config
- Rsmgrpolicy.config
- Reportingservicesservice.exe.config
- Web.config for both the Report Server and Report Manager ASP.NET applications
- Machine.config for ASP.NET
4) Backup the custom Report data files and report models.
These include report definition (.rdl) files, report model (.smdl) files, shared data source (.rds) files, data view (.dv) files, data source (.ds) files, report server project (.rptproj) files, and report solution (.sln) files.
Remember to backup any script files (.rss) that you created for administration or deployment tasks.
5) Backup any custom views and/or stored procedures that you've developed for your custom reports.
Source reference: http://technet.microsoft.com/en-us/library/ms155814.aspx