Post reply

Migrating ReportSever DB from SQL 2008 to SQL 2008 R2 Box

  • March 29, 2012 at 11:16 am

    #253350

    Hello -

    I was just wondering if there are any considerations which I should take into account before I move our current ReportServer DB to a new box. The biggest issue is that i'm moving from SQL Server 2008 to SQL Server 2008 R2 - are there any issues between these two versions if I do a simple detach and attach of the DB? Or is that not recommended between these two versions?

    I should note that i'm not really a server admin or a DBA, i'm more of a developer who has been volunteered to relocate our ReportServer DB.

    Thanks!!

  • March 30, 2012 at 1:25 am

    #1466779

    backup your SSRS encryption keys first,

    backup your SSRS databases

    then either detach/attach or copy/restore or another means of getting the DB from Server1 to Server2

    reconfigure SSRS to point to the new server and DB

    apply your encryption keys

    there are other methods like installing 2008R2 SQL and SSRS fresh out the box, and using tools like RSScriptor to script the objects and redeploy them or if you still have the solutions you can redeploy from BIDS.

    http://msdn.microsoft.com/en-us/library/ms156421%28v=sql.105%29.aspx

    http://www.sqldbatips.com/showarticle.asp?ID=62

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply