Primary server down

• ramyours2003

  SSChampion

  Points: 12268

  More actions

  August 11, 2013 at 11:56 pm

  #297496

  How can we make synchronise of data when the primary server down in log shipping and we have no witness server ?

• raadee

  SSC Eights!

  Points: 881

  More actions

  August 12, 2013 at 1:08 am

  #1640456

  To failover to a log shipping secondary, just follow have a look at this article. Do not miss out on that .3 in the article talks

  about a tail-log backup.

  http://technet.microsoft.com/en-us/library/ms191233(v=sql.105).aspx

  There is no concept of a witness in log shipping, witness is used for mirroring.

  But there the concept of monitoring your log shipping setup.

  http://technet.microsoft.com/en-us/library/ms190224.aspx