September 23, 2015 at 2:22 am
Hi
I want to implement 2 node Active/Active sql server fail over cluster instance (Version 2014) with database replication, integration & reporting service, appreciate if someone can give the clear guidance to archive this challenge
Node 1
Instance 1 Active
Separate Shared Storage for database file (E:)
Node 2
Instance 2 Active
Separate Shared Storage for database file (F:)
Node 1
Database 1 should be replicate to node2
Node 2
Database 2 should be replicate to node1
1. Is this possible to do
2. If node 1 instance 1 fails, instance 1 should be fail over to Node 2 with the replication
2.1 if Node 1 instance 1 fails will the replication continue working
3. If node 2 instance 2 fails, instance 2 should be fail over to Node 2 with the replication
3.1 if Node 1 instance 1 fails will the replication continue working
so any help or advice would be greatly appreciated.
Thanks
Harshana
October 18, 2015 at 2:34 am
If configured correctly, replication will resume after a SQL Server restart, and a failover can be seen as a SQL Server restart. So, if you replicate from instance 1 to instance 2, and instance 1 fails over to another node, replication should resume.
But if I understand your question correctly, you are asking some very basic questions for a very complicated scenario. Personally, I would not recommend using either clustering or replication in production without a thorough understanding of the technology, and I surely would not recommend using both. If I may ask, what requirements do you have to use both clustering and replication?
October 19, 2015 at 1:43 am
Hi Robert
Thank you very much for your reply.
Anyhow I have installed & configured correctly now its up & running.
Thanks again your reply.
Harshana
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply