SSRS 迁移

9/1/2015来源:SQL技巧人气:2014

SSRS 迁移

一、数据库备份

  备份源数据库:ReportServer和ReportServerTempDB (注意是全备份)

二、数据库还原

  还原之前先停掉SSRS

  

  还原至目标数据库:ReportServer和ReportServerTempDB

三、Encryption Keys

  备份源Encryption Key

  

  还原至目标服务器:步骤类似如上,只是使用Restore即可

四、帐号及恢复

  新建SSRS登录帐号,具体请参考文章

  由于是备份还原方式,所以目标机器上的所有报表以及报表的订阅者都是以前源机器的登录帐号,需调整成目标机器上面新建的帐号,研究下来,可以后台更改数据库达到此目的,打开ReportServer,查询

SELECT * FROM USERS 

  找到源和目标的用户,执行类似以下命令(直接调换两个用户信息)

update Users set Sid = 0x0105000000000005150000007F7120D7B02B31DAE7C1DA3DF1030000 where userid = 'EEF5FFA5-575C-43A4-BDE5-7ABD526AB156'update Users set Sid = 0x0105000000000005150000008BCAD5FC16C2212B60D2A8FBF2030000 where userid = '170B5127-2BAA-410F-8F33-487141282680'update Users set username = 'report_admin',Sid = 0x0105000000000005150000007F7120D7B02B31DAE7C1DA3DF1030000 where userid = 'EEF5FFA5-575C-43A4-BDE5-7ABD526AB156'update Users set username = 'CMASHG_2\lms',Sid = 0x0105000000000005150000008BCAD5FC16C2212B60D2A8FBF2030000 where userid = '170B5127-2BAA-410F-8F33-487141282680'

  https://msdn.microsoft.com/en-us/library/dn531017.aspx