Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 2005 » Administering » mirroring
Add to briefcase

mirroring Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
sandhyarao49
Posted Tuesday, June 10, 2008 3:27 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, February 18, 2013 9:50 PM
Points: 119, Visits: 650
In database MIrroring mirror is in sync with principal.
we have a witness server.
if Principal goes down mirror will up and take over the application.
Witness server is responsible for that.
Technically could any one tell me whats happening inside the witness server. how the Pricipal will failover to mirror.

Waiting for ur replies.
thanks,
sandhya.
Post #514244
Yelena Varshal
Posted Tuesday, June 10, 2008 9:12 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, July 30, 2012 10:42 AM
Points: 3,434, Visits: 519
Hello Sandhya

Please read this article, it explains the sequence of events for different Mirroring Operating Modes and scenarios.

http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx
Database Mirroring in SQL Server 2005

Regards,
Yelena Varshal
Post #514536
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.