Here's the scenario
Production SSRS is on SQL 2005 SP3.
DR SSRS is on SQL 2008
I've got a backup from the Production SSRS and want to use it on the DR box.
When I point the SSRS instance on DR to a restore of the Production backups I get
the version of the report server database is either in a format that is not valid"
The found version is c.0.8.54. The expected version is c.0.9.45 (rsInvalidReportServerDatabase)
Has anyone been able to do what I'm trying successfully ?
I had hoped that the SSRS configuration utility on SQL 2008 would apply the necessary changes to the ReportServer database to bring it from the SQL 2005 schema to the SQL 2008 schema ?
Any help appreciated !