Primary server failed in log shipping

• Rajat Jaiswal-337252

  SSCommitted

  Points: 1779

  More actions

  August 10, 2010 at 4:10 am

  #387540

  Hi,

  When primary server failed we trun secondary server "with no recovery" option.

  but now when my primary server up. how to apply log shipping agin.

  is there any way like mirroring.

  Thanks

  Rajat

• crazy4sql

  SSCoach

  Points: 19590

  More actions

  August 10, 2010 at 4:16 am

  #1204601

  setup the restoration job again and make sure it change the database status to standby or readonly mode

  ----------
  Ashish