DB Mirroring for transactions committ

• mohan.bndr

  SSCrazy

  Points: 2360

  More actions

  July 18, 2013 at 4:39 am

  #277616

  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 !!!

• s_osborne2

  SSCertifiable

  Points: 6726

  More actions

  July 18, 2013 at 5:53 am

  #1633604

  Transactions continue to commit on the principal.

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

  Thanks,

  Simon

  ---

  
  MCSE: Data Platform
  MCSE: Business Intelligence
  Follow me on Twitter: @WazzTheBadger
  LinkedIn Profile: Simon Osborne