August 27, 2009 at 11:05 am
Hi,
We have 2 SQL Server 2005 servers, Server A & Server B and one MOSS 2007 Apllication Server called Server C. Server A is for Database engine and Server B is for only Reporting services(the ReportServer & ReportServerTempDb are on Server A instance) on Primaty Location. We are implementing Disaster recovery using Log shipping. In this case on Seconday location:
1. We have build one SQL Server 2005, called DRServer A and installed SQL Server 2005
2. Build Moss 2007 Application Server called DRServer C and installed Moss 2007.
3. Implemented Log shipping between Primary SQL Sevrer (Server A) and Secondary SQL Sevrer (DRServer A) (Here I did not set up Log shipping for ReportServer and ReportServerTempDB)
My Question is How can we implement Disaster recovery set up for Reporting services?
Thanks for your inputs
August 27, 2009 at 11:33 am
My Question is How can we implement Disaster recovery set up for Reporting services?
The link below is called a migration guide for SSRS from one server to another you may just need how to move ReportServerDB and ReportServerTempDB. So make sure you have simple recovery backup of ReportServerTempDB and Full recovery backup of ReportServerDB and Full Recovery backup of your datasource database. Then all you need are the SSRS configuration utilities covered in the link below. You will also find how to move ReportServerDB and ReportServerTempDB in the same link.
http://msdn.microsoft.com/en-us/library/ms143724(SQL.90).aspx
Kind regards,
Gift Peddie
August 27, 2009 at 12:07 pm
Thanks,
I'm not migrating the Reporting Services one server to other
We want to have a standby server always on Secondary Location for SSRS too. From our setup so far we are 100% succeeded in Log ship all the databases and point the application to the secondary databases except Report server & ReportServerTempDB
I'm thinking in this way. Please correct me if I'm wrong
1. Build a new Server for Reporting Services (DRServer B)on Seocndary Location and install only SSRS
2. While configuring Report Server & ReportServerTempDB, Select the DRServer A.
3.Delete these 2 databases from DRServer A.
4.Log shipping Report Server & ReportServerTempDB from Server A(primary location)
5. Point the DRServer B, to the newly log shipped Report Server & ReportServerTempDB
Is the above works?
August 27, 2009 at 12:43 pm
Mani (8/27/2009)
Thanks,I'm not migrating the Reporting Services one server to other
We want to have a standby server always on Secondary Location for SSRS too. From our setup so far we are 100% succeeded in Log ship all the databases and point the application to the secondary databases except Report server & ReportServerTempDB
I'm thinking in this way. Please correct me if I'm wrong
1. Build a new Server for Reporting Services (DRServer B)on Seocndary Location and install only SSRS
2. While configuring Report Server & ReportServerTempDB, Select the DRServer A.
3.Delete these 2 databases from DRServer A.
4.Log shipping Report Server & ReportServerTempDB from Server A(primary location)
5. Point the DRServer B, to the newly log shipped Report Server & ReportServerTempDB
Is the above works?
I think that woks!
But, what is your approach in case of Server B failure?
Best Regards,
SQLBuddy
August 27, 2009 at 1:06 pm
I don't know why Microsoft called that document a migration guide but it is a recovery guide because it contains the utilities that will recreate SSRS. Log Shipping will give you all the databases but SSRS is more than the databases. Here is a short version of that document which covers the utilities not included with your Log Shipping if your server goes down.
http://support.microsoft.com/kb/842425
Kind regards,
Gift Peddie
August 28, 2009 at 12:25 am
for SSRS you can think about Mirroring if possible in your scenario.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply