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

witness server Expand / Collapse
Author
Message
Posted Thursday, November 22, 2012 10:14 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, December 30, 2012 11:12 PM
Points: 3, Visits: 54
with out witness server can we set up mirroring?
Post #1388022
Posted Friday, November 23, 2012 4:19 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Friday, July 25, 2014 8:43 AM
Points: 709, Visits: 1,411
If automatic failover is required, then you must have a witness. Otherwise no, it is not required.

Database Mirroring Overview


Joie Andrew
"Since 1982"
Post #1388113
Posted Monday, November 26, 2012 4:57 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 2:17 AM
Points: 203, Visits: 499
actually witness server is an optional requirement in mirroring. If you choose "High Safety With Automatic Failover" option, then you need a witness server.
Post #1388538
Posted Monday, November 26, 2012 7:45 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:15 AM
Points: 6,182, Visits: 13,329
shohelr2003 (11/26/2012)
actually witness server is an optional requirement in mirroring. If you choose "High Safety With Automatic Failover" option, then you need a witness server.

It's an option for Syncrhonous mirroring, although you can have a witness in Asynchronous mirroring Microsoft highly recommend you don't!!


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

"Ya can't make an omelette without breaking just a few eggs"
Post #1388636
Posted Tuesday, November 27, 2012 12:06 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 2:17 AM
Points: 203, Visits: 499
Perry Whittle (11/26/2012)
although you can have a witness in Asynchronous mirroring Microsoft highly recommend you don't!!


Thank You for this information.
Post #1388983
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse