February 3, 2012 at 1:39 pm
Hello experts!
Here is the setup - I have 3 servers used in a transactional replication in our main location - main db server as publisher of 10 databases, stand alone distributor and reporting server as subscriber to all 10 databases. All servers are 64-bit Windows 2008 with SQL Server 2008 R2 Standard. Some of the replicated databases are large and if subscription needed to be re-initialized it would take up to 24 hours from start to finish. We have a DR site in a different location and use CA XOSoft block synchronization replication to keep main DB server and DR server synchronized.
I need to add my reporting server to this setup and minimize downtime as much as possible. At this moment I am at a total loss - as far as I know I cannot keep replication going from DR site because all servers will have different physical names (or can it still work with XOSoft fail over mechanism?). I cannot run synchronization from DR publisher to DR subscriber because it will take 24 hours to get all data up to date (although @david-2 Benoit gave me a great idea about "replication support only" option).
Also, both sites (main and DR) use SAN for all server storage.
I will take any suggestion or brain storm ideas.
Thanks a lot!
February 15, 2012 at 3:34 am
I'm not quite sure exactly what you're asking here. Some years ago I looked into using san replication but there is/was the distinct possibility of getting inconsistant data in the event of a failure - e.g. in a database with several files groups the replication at block level may not ( well wouldn't ) actually have the exact time slice for the data and log files. When you test these types of things it's all very different to a proper data centre failure, try pulling the cables/power/networks and see if it all works!
I don't really see the issue of SSRS in DR, if your solution works for SQL Server it should work for SSRS - if it's names/ips then that's a matter of choice either using a different url or some other solution availabel for quick redirection of dns.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply