February 26, 2009 at 9:19 am
Hi all,
I will shortly be moving our production Reporting Services from one server to another. The source server is 32-bit Standard Edition SQL Server 2005 SP3 and I will match that on the destination server. The only difference between them will be the operating system (going from Windows Server 2003 to Windows Server 2008) but I am comfortable with what I need to do for that aspect.
My question is, should the source server system databases be moved to the destination as part of this exercise as well? Or is this actually a bad idea? There are a lot of jobs, which I think have been automatically generated by Reporting Services, which run code on the master database such as:
exec ReportServer.dbo.AddEvent @EventType='TimedSubscription', @EventData='0be8b039-f671-4c43-8a7a-8d8abcf90c7a'
plus things such as logins/users etc... I know they can be scripted out if necessary, but I prefer the backup and restore method.
I have read through the articles:
http://support.microsoft.com/kb/842425
http://frankkerrigan.blog.co.uk/tags/move-2005-reporting-services/
...and neither seem to mention the system databases at all. When I have moved SQL Server systems before I have usually moved the system databases as part of the exercise t keep everything the same.
Some guidance on this aspect would be much appreciated please. Apologies in advance if I have missed some instructions/forum posts which already answer this question.
Regards,
Chris
February 26, 2009 at 9:44 am
I think you just need to use the support article and the code and instructions in the link below. The reason is you need to create the Backup devices which loads both databases into the Master of the new server so you don't need the system databases of the old server. If you don't create the Backup devices you may get SSRS not initialized error which just means the relational engine in the new server does not know your SSRS.
http://technet.microsoft.com/en-us/library/ms156421.aspx
Kind regards,
Gift Peddie
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply