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.

Avoid pop up RS reports on sharepoint

Hi,

Current, I have a web part which points to the report explorer. The first page is a list of the reports on the reportserver, when I clicked on the link of the one of the reports, it pop up a window to show the report, which behave exactly like http://reportserver/Reports. Is there a way to stop it from poping up a new window, and just show the report on the same page where the link was clicked?

Thanks,

Cheng

While rendering the report you could use the rc:TargetLink=_self paramter, which willopen all links in the same window.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de