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

DB Mirroring for transactions committ Expand / Collapse
Author
Message
Posted Thursday, July 18, 2013 4:39 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Friday, June 27, 2014 6:10 AM
Points: 104, Visits: 400
Hi All,

Under high safety mode for DB Mirroring , the transactions will get committed in mirror server first and it passes the acknowledge on successful committing and after that the transaction get committed in Principal server.

In this senario What will happen if the mirror is down? Will SQL wait for the acknowledgement from Mirror?

Please help me out !!!

Post #1474965
Posted Thursday, July 18, 2013 5:53 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: Wednesday, July 23, 2014 9:02 AM
Points: 702, Visits: 2,171
Transactions continue to commit on the principal.

Read this: http://msdn.microsoft.com/en-us/library/ms179344(v=sql.105).aspx

Thanks,


Simon




MCSA: SQL Server 2012
Follow me on Twitter: @WazzTheBadger
LinkedIn Profile: Simon Osborne
Post #1474988
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse