Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Initialise SSRS on SQL 2008 from backup taken from SSRS on SQL 2005 Expand / Collapse
Author
Message
Posted Monday, March 11, 2013 3:40 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, April 11, 2014 7:28 AM
Points: 162, Visits: 726
Hi all,

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 !
Post #1429507
Posted Friday, April 05, 2013 3:09 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 7:15 AM
Points: 572, Visits: 2,069
When i did my upgrade I had two reoccuring errors. One was the one that you had. Do your reports have background images in the headers? if so try removing them. I know it's strange but that fixed it for me. If that's not the case I'll have to do dome digging to see what the other fix was.
Post #1439498
Posted Friday, April 05, 2013 3:27 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 7:15 AM
Points: 572, Visits: 2,069
Sorry, i totally misread your post. My error was totally different. I read to fast and my mind filled in the blanks.
Post #1439506
Posted Saturday, April 06, 2013 3:20 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, April 11, 2014 7:28 AM
Points: 162, Visits: 726
No problem Steven.

In the end I just used a different server running the same version of SQL.
Post #1439559
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse