Retrieving rdl from Server

I did a dumb thing and managed to clear out a file with a bunch of reports in it. We are having problems pulling the reports from the backup tapes. Is there a way to retrieve the rdl from the report server? It is about 12 reports and I would rather not have to recreate them.

There are many ways to retrieve the RDLs from the report server (assuming you have permissions beyond just "Browser" permissions).

* Manual retrieval:
You can retrieve the RDL for published reports by switching to the details view in report manager (http://localhost/Reports/Pages/Folder.aspx?ViewMode=Detail) and then clicking the edit icon next to the report you are interested in. This will bring up the "report properties" page. On the general tab of that page, there is a "Report Definition" section with an "Edit" button. Click on the "Edit" button and you can retrieve the RDL file from the ReportServer.

* Management Studio:
With the SQL Server 2005 Management Studio you can connect to the report server and manage your reports (including retrieving RDLs).

* SOAP API:
You can use the SSRS SOAP API to retrieve report definitions. Use the GetReportDefinition method: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_ref_soapapi_service_ak_2eew.asp

* RS Scripter tool:
Download Jasper Smith's RS Scripter tool: http://www.sqldbatips.com/showarticle.asp?ID=62

-- Robert

|||I should have mentioned that I am running RS2000 sorry. The Scripting tool was extrememely helpful though.sql