Redundant SQL Server connection

0 vote

avatar

Hi David,

i've setup a redundant SQL Server 2008 database environment with the SQL Mirroring feature.
Is it possible to implement the "Failover Partner" (or "Mirror Server") option to use this for the SQL Server connection.

Thanks
Dirk Schmitz

All Comments (4)

avatar

Hi,
I added this my feature request list. Just to be sure, you want to configure in the data source another server ?

David Hervieux
Devolutions inc.

David Hervieux

avatar

Hi David,

it's not just like another server in the data source. "Failover Partner" it's a function of the SQL Native Client .
Take a look at http://technet.microsoft.com/en-us/library/cc917713.aspx#ECAA

avatar

Hi,
Thank you for the information. I will take a look at this.

David Hervieux
Devolutions inc.

David Hervieux

avatar

Hi,
Watch for the next beta, failover partner is available in the advanced settings.

David Hervieux