Recovering a Deleted or Messed Up SSRS Report

This is the first time I needed to restore an SSRS report and the snapshot history was not working on the server. I’m actually surprised that I didn’t need this before now. But I found a wonderful super easy way to do this. Not sure what others have done or if there is a better way.
Also, make sure you are regularlly backing up your SSRS Databases!

1 Like

Thanks for sharing Rick!

1 Like

Maybe we should also consider keeping source code like RDL files in a repository? Versioned backup if you will… :thinking:

2 Likes

Hey Everyone, I looked at this old post and it was a good starting point, I figured there had to be a more simple solution.

And I found one!

Recently had to recover from a ransom ware attack, We had a copy of the ReportServer database, I restored the Report Server database as ReportServer_Old. I needed a list of all our custom reports and the location, some were stand alone and some in folders from the Copy SSRS function in Kinetic.

The main table you are interested in is Catalog.
Three fields: Name, Path and Content.

Here is the SQL Query I used on that database:

SELECT Name, PATH, Convert (XML, Content) From Catalog
WHERE [Path] Like ‘/EpicorERP/reports/CustomReports/%’

Since I needed to find all of my custom SSRS reports I wanted to see everything with that path. You can always change the where clause to narrow down your search. If you know the name of the report, you can use: Where Name = ‘ReportName’.

In the results simply double click on the XML, it will open in its own tab.
Save the XML.

Change the extension to RDL and Upload it.

I had to make copies of the original SSRS reports in Kinetic to restore the location Since I had a new clean install of Kinetic, then upload the RDL to the original location or those newly recreated spots.

5 Likes