database mirroring

• Jan-155192

  SSCrazy

  Points: 2613

  More actions

  April 24, 2007 at 12:50 am

  #173734

  Hi,

  I have a general question on database mirroring in synchronous mode. As I understand, in this mode a transaction is only commited when the standby server can also commit to it (2phase protocol). But hasn't that an impact on autonomy? What if the standby server would go down? Aren't clients able to commit anymore? Doesn't that run contradictory to the whole idea in the first place? Or does mirroring degrade to asynchronous mode automatically? At the cost of TLogs growing?

  I seem to be missing something here?

  Regards,

  Jan

• Zaheer-354434

  Newbie

  Points: 6

  More actions

  May 14, 2007 at 6:36 am

  #706195

  Hi

  Find Useful article on this site

  http://msdn2.microsoft.com/en-us/library/ms179344.aspx

   

• Sugesh Kumar

  One Orange Chip

  Points: 27311

  More actions

  July 6, 2007 at 12:32 am

  #717579

  There is a document available in msdn by Ron Talmage titled 

  Database Mirroring in SQL Server 2005

  That has all the scenarios that can occur and the way how sql handles all scenarios.

  Cheers,
  Sugeshkumar Rajendran
  SQL Server MVP
  http://sugeshkr.blogspot.com