Learn how to a build a cloud-first strategyRegister Now



Posted on 2006-05-19
Medium Priority
Last Modified: 2013-11-15
I have 2 servers one is a hot standy.  I am thinking of configuring them to be a cluster.  My queastion is that I have a "Connect Direct" application that copies from my primary server every night. If  a failover occurs will the "Connect Direct " application  fail??


Question by:398669
LVL 28

Expert Comment

ID: 16723927
Yes if it is connected to the node rather than the virtual server name (cluster)
LVL 10

Expert Comment

ID: 16731382
In a SQL Cluster you have active node server1 and a passive node server2 ...  (you can have a active / active cluster but thats another story)  ...   and you client conects to a virtual ip adderss ...   if the active node server1 falls over server2 becomes the active node and accepts all requests form the virtual ip address ....   So point you app at the virtual ip and you will be ok  

Accepted Solution

lokeshgm7 earned 2000 total points
ID: 16731710
Read this article to understand High Availability in Clustering.



Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to use a free utility called 'Parkdale' to easily test the performance and benchmark any Hard Drive(s) installed in your computer. We also look at RAM Disks and their speed comparisons.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
This tutorial will walk an individual through the process of installing of Data Protection Manager on a server running Windows Server 2012 R2, including the prerequisites. Microsoft .Net 3.5 is required. To install this feature, go to Server Manager…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question