backing up reporting services

A few questions regarding Reporting Services

what needs to be backed up for reporting services? We are currently backing up the ReportServer and ReportServerTempDB.

Where would the RDL files be saved on our reportserver?

Finally, is there anything else that should be backed up for disaster recovery purposes?

You don't need to backup ReportServerTempDB for disaster recover. All of the data in it is transient.

You should also backup the key which is used for encrypting data in the ReportServer database.

See this article for a pretty good rundown of all of the pieces that you will want to backup:

http://technet.microsoft.com/en-us/library/ms155814(SQL.90).aspx

|||

>>Where would the RDL files be saved on our reportserver?

I'm pretty sure that the RDL files are stored in binary form (in the Content column of the Catalog table?) in the database, not positive.

>>is there anything else that should be backed up for disaster recovery purposes?

I would also back up the various *.config files from the ReportServer/Manager installation, plus any custom DLLs you may have added to a vanilla installation.

>L<

|||The RDL is stored in the catalog. You can retrieve it by using the GetReportDefinition() SOAP API call.