The ADO.NET Client can help you make sure that your critical data is available even if the primary database server is unavailable:
Connection failover allows an application to connect to an alternate, or backup, database server if the primary database server is unavailable, for example, because of a hardware failure or traffic overload. See Specifying Alternate Servers for more information.
Connection retry defines the number of times the ADO.NET Client attempts to connect to the primary server and, if configured, alternate database servers after the initial unsuccessful connection attempt. See Using Connection Retry for more information.
Client load balancing helps distribute new connections in your environment so that no one server is overwhelmed with connection requests. See Using Client Load Balancing for more information.
Connection failover allows an application to connect to an alternate, or backup, database server if the primary database server is unavailable, for example, because of a hardware failure or traffic overload. See Specifying Alternate Servers for more information.
