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

DBMirroring Mirror DB Transaction Status Expand / Collapse
Author
Message
Posted Monday, April 29, 2013 2:55 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, April 29, 2013 8:25 AM
Points: 10, Visits: 159
In High safety mode without automatic failover, Principal database waits for the acknowledgement from the mirror database. If changes has been made on the mirror and acknowledgement is sent but it could not reach the principal due to some network/hardware issue , transaction on principal will be rolled back as it could not get acknowledgement . Now what will happen to the data committed on the mirror database ( IN a DR Scenario where no principal is available)

Thanks in advance
Murali

Post #1447408
Posted Monday, April 29, 2013 6:02 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Today @ 6:09 AM
Points: 742, Visits: 1,064
Mirror will become the Primary.
Post #1447465
Posted Monday, April 29, 2013 6:44 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 6:32 AM
Points: 221, Visits: 1,690
Neeraj Dwivedi (4/29/2013)
Mirror will become the Primary.

No, won't be, and transactions will commit without any errors.
Without a witness, you must failover manually and what is worse even in safety FULL without a witness mode you could lost some data if mirror wasn't synchronized.
Post #1447484
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse