Skip to main content

Migration of Reporting service from sql ...

Migration of Reporting service from sql server 2005 to sql server 2008(R2)

Source ServerName: ServerA New ServerName: ServerB 1. Backup ReportServer and ReportServerTemp dbs from source server ‘ServerA’. 2. Backup RS Encryption key from source server ‘ServerA’. Go to Reporting Service configuration Manager in ServerA. From encryption tab, you can backup the encryption key. 3. Restore ReportServer and ReportServerTemp dbs on New server- ServerB. 4. Configure the […]

Welcome to My Cool DBA Site

Welcome to My Cool DBA Site

We all know DBAs are always cool  😛 . This website always contains database fun with lots of very important information which helps DBA to perform different task and troubleshoot. You can always send me feedback and questions to me. – Ashok