question

Mrs_Fatherjack avatar image
Mrs_Fatherjack asked

SSRS restore report from DB

I am new to an environment and apparently some reports have gone missing, there are no .rdl files that we can fine anywhere. The reports would have been deployed to a cluster and apparently that makes a difference. We can restore the folder that the files would have been saved in but the opinion here is that reports in a cluster are only saved to the database, is this the case? How can I get these reports back? I'm very unfamiliar with the entire environment as this is day 1 in a new job. Many thanks for any advice
ssrsreportserverdeleted-reports
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
@SQLShark avatar image
@SQLShark answered
Have you looked in the report server db to see if the there is still a record of the report? If the report has been deleted from the report server then it might be missing. I assume that they have back ups of the report server? Restore the report server to another DB and pull the RDL from the catalog table. OR download the SSIS package from here [ https://ssrscatalogqueries.codeplex.com/][1] , restore the db. Point this at the DB and strip all the RDLs out. Then upload back to report manager. [1]: https://ssrscatalogqueries.codeplex.com/
4 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image ThomasRushton ♦♦ commented ·
@Mrs_Fatherjack - have you blogged / posted your solution somewhere? Just thinking about various DR options for SSRS here...
1 Like 1 ·
Mrs_Fatherjack avatar image Mrs_Fatherjack commented ·
I haven't but I will give it a go.
1 Like 1 ·
David Wimbush avatar image David Wimbush commented ·
Wow, that's a tough first day. Good work to fix that.
1 Like 1 ·
Mrs_Fatherjack avatar image Mrs_Fatherjack commented ·
Thanks for this, we restored from a backup of the DB, then used a powershell script to rebuild the .rdl files.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.