Mirroring in Stand by mode

• mohan.bndr

  SSCrazy

  Points: 2360

  More actions

  February 25, 2016 at 10:25 pm

  #325070

  Hi All,

  Is that possible stand by mode in mirroring ? if not then tell the reasons as it not being put in stand by mode......

  Thanks in advance and post me your suggestions.

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  February 26, 2016 at 2:03 am

  #1861330

  No it's not. Mirroring requires that the DB be restored WITH NORECOVERY.

  Standby does a partial recovery and writes what it rolled back to a file in order to make the DB readable. When the next log backup is restored, that gets redone and then the log gets replayed. Mirroring is 'continual' restores, so it's not possible to have the DB in a read only state while there are log records are continually being restored.

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• Jon.Morisi

  SSChampion

  Points: 12846

  More actions

  February 26, 2016 at 1:56 pm

  #1861558

  Are you aware of AlwaysOn Availability Groups?