Migrate Databases Report Server and Report Server tempDB

Question

Migrate Databases Report Server and Report Server tempDB

WhiteLotus

SSChampion

Points: 12122
More actions
April 4, 2016 at 7:05 pm

#315057

Hi All,
I am about to migrate some databases consist of user databases and also Report server and Report server TempDB from 1 server to another server
Question :
The destination server already have Report Server and Report Server TempDB , so should I still move the Report server and Report Server TempDB from Original Server ?
Any feedback are really appreciated !
Cheers

Viewing 7 posts - 1 through 6 (of 6 total)

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

WhiteLotus SSChampion Points: 12122 More actions · Answer 1

In addition These 2 servers has different function ( and different databases ) so this migration is for Consolidation purpose ( easy to manage )

Alan Burstein SSC Guru Points: 61141 More actions · Answer 2

WhiteLotus (4/4/2016)
Hi All,
I am about to migrate some databases consist of user databases and also Report server and Report server TempDB from 1 server to another server
Question :
The destination server already have Report Server and Report Server TempDB , so should I still move the Report server and Report Server TempDB from Original Server ?
Any feedback are really appreciated !
Cheers

There should be no problem moving the ReportServer databases to a new server if you need to move them. You'll just need to change the names of the databases (e.g. ReportServer01, ReportServerTempDB01). Once you've moved these databases you'll need to point SSRS to where you moved the databases by going into Reporting Services Configuration Manager > Database.

"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

-- Itzik Ben-Gan 2001

WhiteLotus SSChampion Points: 12122 More actions · Answer 3

Thanks for the reply !

I just checked the destination server and it has reporting services running there also when I go to Reporting Services Configuration Manager > Database, It points to the ReportServer database.

Question :

Since it will only point to 1 database which is Reportserver from that Original server then how do I point to another Report Server that I have just migrated ( from original server) ?

BLOB EATER SSChampion Points: 14609 More actions · Answer 4

Go into RS - Configuration manager > Database section - here is the option to change database.

Side note don't forget to confirm that RSExecRole has select, insert, update, delete, and reference permissions on the tables, and execute permissions on the stored procedures in RS DB.

BEFORE you do this you need to backup keys. Read this document.

https://msdn.microsoft.com/en-us/library/ms156421.aspx"> https://msdn.microsoft.com/en-us/library/ms156421.aspx

WhiteLotus SSChampion Points: 12122 More actions · Answer 5

The problem is I am not sure that those servers use reporting services . if both use then it means I need to point to 2 different report servers then ?

Moreover should I migrate reportserverTempdb too ?

( in destination server reportserverTempdb is already there )

BLOB EATER SSChampion Points: 14609 More actions · Answer 6

Ok so if you already have a report server on the destination (I'll assume its in use) then why don't you use the reporting services scripter tool to migrate the objects over to it? Works pretty well, especially for 2008R2.