What is the best SQL Server disaster recovery solution?
-
Dear All, We are planning to have a complete solution for SQL Server disaster situation. We will have two servers, one is locally and the other is in another country where we have VPN connections between the two offices. I planned to build a transactional replication with fail over options to redirect our applications to the subscriber server. My question is: Is this option (Transactional Replication) the most useful and best solution for mu purpose? And if it is the best solution, how can our applications redirect to the subscriber server if the primary server is down??? Is there any thing to use that may check the primary server availability and redirect the applications to the subscriber server automatically??? Your help is very very very appreciated Best Regards
Kind Regards OBarahmeh
-
Dear All, We are planning to have a complete solution for SQL Server disaster situation. We will have two servers, one is locally and the other is in another country where we have VPN connections between the two offices. I planned to build a transactional replication with fail over options to redirect our applications to the subscriber server. My question is: Is this option (Transactional Replication) the most useful and best solution for mu purpose? And if it is the best solution, how can our applications redirect to the subscriber server if the primary server is down??? Is there any thing to use that may check the primary server availability and redirect the applications to the subscriber server automatically??? Your help is very very very appreciated Best Regards
Kind Regards OBarahmeh
obarahmeh wrote:
Is this option (Transactional Replication) the most useful and best solution for mu purpose?
Actually there are several ways of doing this, but if your way works for you then it is the best way. Sorry I do not remember how to fail-over. Currently we use log shipping but not the High Availability of it as we manually switch (not my idea). Good luck, and do not forget to practice the fail-over every so often.