RE: how to failover sql server (programming, UDL)

I assume that you are talking about Database Mirroring. A number of
conditions must be met before automatic failover can happen for a client: (1)
database mirroring must be running high-availability mode (with full safety
and a witness), (2) the mirrored database must already be synchronized, and
(3) The mirror adn witness has retained quorum. In addition, the client must
re-try.

See SQL2005 Books Online under "automatic failover" for more info.

Linchi

"stevehunter_1@xxxxxxxxxxx" wrote:

I have set up a UDL with "Failover partner=(server name)" and when i
fail the primary sql server, it does not do anything. When I bring
the primary server back up, everything works fine again.

How are people designing applications with multiple servers? I have 2
servers, replicated with bi-directional transactional replication.

I would like to be able to specify server#1 as the primary, but if
there are errors with server#1 related to connectivity, i would like
to failover to server#2.

Question .. does this exist somehow with ADO or built into sql server
or some interfaces already or do I need to program this on my own? I
am really looking for functionality within sql server and if there is
no functionality there, then this might not be the best group, but how
are people handling this programatically ?




.

Relevant Pages

  • Re: Quorum Disk or Majority Node?
    ... Database Mirroring is already an option. ... See "Sizing a Majority Node Set Cluster" ... When SQL Server 2005 starts supporting database mirroring there is going ... SQL Server does not NATIVELY support MNS clustering. ...
    (microsoft.public.sqlserver.clustering)
  • RE: Auto Failover & DR >>
    ... take transaction log backup in database mirroring scenario. ... DD - SQL server 2005 ... adding the witness to a high ...
    (microsoft.public.sqlserver.clients)
  • Re: Database Mirroring Monitor Job Error
    ... with database mirroring. ... but the Database Mirroring Monitor Job fails every time with ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Database Mirroring Monitor Job Error
    ... We have recently set up two SQL Server 2005 Standard Edition servers ... with database mirroring. ... The mirrors function and fail over without a ...
    (comp.databases.ms-sqlserver)
Loading