SQL Server Mirroring - setting up the initial sync with mirror from backup/logs

• kgautney-728737

  Valued Member

  Points: 60

  More actions

  December 16, 2009 at 10:44 am

  #136011

  I have a DB that is 25 tb in size, we are going to restore the DB and logs to the primary server, then let the primary server sync to the mirror.

  We are going to use synchronous with failover for the mirror, but I hear that can be slower than asynchronous.

  My question is:

  For the initial synch, can we set it to asynchronous, then after the initial load, change it to synchronous. This is just because I want the initial load to be faster.

  Let me know,

  Thanks

• steveb.

  SSC-Forever

  Points: 46733

  More actions

  December 16, 2009 at 11:00 am

  #1093201

  I am not sure that is going to work,

  when implementing mirroring you need to restore the database and logs to the MIRROR server with No Recovery

  then start the mirroring