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

what happened when Mirror server failed in hight safety environment Expand / Collapse
Author
Message
Posted Sunday, October 20, 2013 12:01 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 30, 2013 8:59 AM
Points: 7, Visits: 28
Hi Everyone,

Suppose we have a mirroring with witness server in hight safety(synchronous mode) environment. So my question is:

1:-What happened if mirror server failed and witness & principle is running fine?

As per my understanding mirroring will be disconnected.Please correct me. And if i am wrong,Please provide me the correct answer.

Thanks in advance

Regards
Ajay
Post #1506491
Posted Sunday, October 20, 2013 1:04 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:38 AM
Points: 5,879, Visits: 13,010
that is correct.

as you have a principal and witness you still have a quorum so the principal can still service connections. However mirroring will be suspended. It will resume when the mirror is bought back up. Until that time the log of the principal will not be able to be truncated.

see http://technet.microsoft.com/en-us/library/ms189902.aspx


---------------------------------------------------------------------

Post #1506502
Posted Sunday, October 20, 2013 11:57 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 30, 2013 8:59 AM
Points: 7, Visits: 28
Thanks George for your prompt reply.
Post #1506545
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse