Home Forums Reporting Services Reporting Services Replacing the SSRS server, but not the DB server, how to migrate reports? RE: Replacing the SSRS server, but not the DB server, how to migrate reports?

  • So, based on this, the reports do "live" in the ReportServer databases? As long as I make sure to backup the encryption key(s,) take a backup of the DBs (just in case, remember, the SQL Server hosting the DBs is a separate machine which is NOT being changed,) then load up the new machine, restore the cert(s), and I should be good to go?

    Well, other then the Devs and users changing their Reporting Services connections...

    Jason

    Since your ReportServer databases are on a different server you don't need to back up the db. Just back up the encryption key(s,) on the current machine, install reporting services on the new machine and point the database to the existing DB and then restore the encryption key(s,).

    For your anticipated question. Yes the actual reports live in the ReportServer database table called catalog, incase you wanna browse it.