Log Shipping

• Nita Reddy

  SSCarpal Tunnel

  Points: 4182

  More actions

  February 6, 2015 at 11:49 am

  #315073

  I need to do maintenance on production server and make DB as simple recovery mode for some reason, that DB is setup as Log shipping and I have to break it when I change DB to simple recovery mode. What should I do make Log shipping working after maintenance.

  Nita

• lmarkum

  SSCertifiable

  Points: 7989

  More actions

  February 8, 2015 at 10:00 pm

  #1776288

  I would do an internet search for "Log Shipping." There are a lot of resources that discuss how Log Shipping works and how to get it going when it has to be stopped or torn down. After looking at thoat if you have a specific question about the process then I would post that here.

• Perry Whittle

  SSC Guru

  Points: 234013

  More actions

  February 9, 2015 at 4:03 am

  #1776328

  Nita Reddy (2/6/2015)

  ---

  I need to do maintenance on production server and make DB as simple recovery mode for some reason, that DB is setup as Log shipping and I have to break it when I change DB to simple recovery mode. What should I do make Log shipping working after maintenance.

  Nita

  Steps would be

  • disable the primary log backup job and the secondary copy and restore jobs.
  • Disable any full backup on the primary
  • switch to simple and complete the work.
  • switch back to full recovery
  • take a differential backup on the primary.
  • restore the differential backup to any secondary databases.
  • Renable all primary and secondary jobs

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs" 😉