Re: SQL 2005 Mirror - newbie question

Tech-Archive recommends: Fix windows errors by optimizing your registry



Answer = it depends, see all the ways you can set it up:

http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx

Cheers,

Rodney R. Fournier

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner


"Imran Vilcassim" <imran@xxxxxxxx> wrote in message
news:D435EFD4-9380-4920-9082-FDE1F0C01385@xxxxxxxxxxxxxxxx
Hi,
when i setup mirroring between two databases, how does failover happen
at
the client. if i setup a principal, a mirror and a witness, how does the
client redirect it self to the mirror server automatically?

would appreciate if someone could point me in the right direction.

regards
Imran


.



Relevant Pages

  • Wanted: A few good Clustering Program Managers!
    ... The clustering team is looking for two new Program Managers. ... Does meeting that need with Windows technologies excite you? ... passionate about driving one of the pillar features for Windows Server? ... The Windows high availability team is responsible for both the Failover ...
    (microsoft.public.windows.server.clustering)
  • RE: Wanted: A few good Clustering Program Managers!
    ... PSS (Clustering team) in 2004. ... Does meeting that need with Windows technologies excite you? ... passionate about driving one of the pillar features for Windows Server? ... The Windows high availability team is responsible for both the Failover ...
    (microsoft.public.windows.server.clustering)
  • RE: Wanted: A few good Clustering Program Managers!
    ... PSS (Clustering team) in 2004. ... Does meeting that need with Windows technologies excite you? ... passionate about driving one of the pillar features for Windows Server? ... The Windows high availability team is responsible for both the Failover ...
    (microsoft.public.windows.server.clustering)
  • Re: Take a Sneak Peak at the Future of Server Clustering
    ... MVP - Windows Server - Clustering ... > a new tool called the Microsoft Cluster Configuration Validation Wizard ... > industry for a decade and was a enterprise network administrator and MCSE ...
    (microsoft.public.windows.server.clustering)
  • Re: NLB for DNS
    ... MVP - Windows Server - Clustering ... classic primary/secondary in for non AD DNS. ... Windows Server MVP - Directory Services ...
    (microsoft.public.windows.server.clustering)