Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

mirroring Expand / Collapse
Author
Message
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
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: Tuesday, July 8, 2014 12:24 PM
Points: 3,475, Visits: 579
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
Posted Thursday, June 27, 2013 3:01 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, June 1, 2014 10:01 AM
Points: 7, Visits: 9
check the below notes ...

MS SQL 2008 Server Mirroring Guide.......http://bit.ly/1a7ZExZ
Post #1468029
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse