changing from NO RECOVERY to STANDBY

• winston Smith

  SSCoach

  Points: 19500

  More actions

  August 27, 2009 at 2:13 pm

  #210130

  on my primary instance i changed the monitor server from NO RECOVERY to STANDBY. It did not have any effect, and the secondry database on the secondry server is still in NO RECOVERY mode. Do I have to reinitialize LOG SHIPPING for this chage to take effect?

• winston Smith

  SSCoach

  Points: 19500

  More actions

  August 27, 2009 at 2:18 pm

  #1045859

  please disregard my silly question. i had forgotten to update the job schedules. all is working fine now.

• Anam Verma

  SSCertifiable

  Points: 5365

  More actions

  September 14, 2009 at 10:53 pm

  #1053561

  did secondary server changed to Standby mode?