AlwaysOn Synchronous mode vs Asynchronous mode

• yujinagata72

  Ten Centuries

  Points: 1072

  More actions

  January 31, 2018 at 6:37 pm

  #328778

  Hi,
  If we use Asynchronous mode, potentially it could be some data loss?

  Thanks,

• TheSQLGuru

  SSC Guru

  Points: 134017

  More actions

  January 31, 2018 at 6:58 pm

  #1978119

  yes

  Best,
  Kevin G. Boles
  SQL Server Consultant
  SQL MVP 2007-2012
  TheSQLGuru on googles mail service