Import SSRS reports from failed database, SQL Server 2016.

David Cummings
David Cummings used Ask the Experts™
I have a SQL Server Reports database (mdf & ldf) that survived the crash of a SQL server which had to be rebuilt.  The tables are valid.  I can do queries on them, such as

select * from catalog

the most important table, as I understand it.

But I cannot use the database as a data source in my newly built SQL Server.  I get an error trying that.

So I built
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Database Analyst
Please have a look at the PowerShell script that exports all (or filtered) reports, data sources and images directly from the ReportServer database to a specified folder here: https://gallery.technet.microsoft.com/scriptcenter/Export-of-all-SSRS-reports-57910227/view/Discussions and hopefully you can use it to get all you can save from the old ReportServer database.
Thanks!  Looking at this now.
That worked beautifully.  Thank you.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial