Log Shipping

• Nita Reddy

  SSCarpal Tunnel

  Points: 4182

  More actions

  October 13, 2015 at 8:29 am

  #304177

  I have set up log shipping and inserted 100 rows in primary server to test but I don't see data on secondary Log shipping server (Secondary Log shipping DB is Read_Only mode). When I run manually backup Job and do same on Secondary Job to restore it works fine. When it runs on schedule job interval of every 15 minutes it shows successfully but I don't see data on secondary server.

  So bottom line when it runs automatically I don't see data and same job when I run manually it works fine.

  Regards,

  Nita

• Perry Whittle

  SSC Guru

  Points: 234013

  More actions

  October 13, 2015 at 8:35 am

  #1833006

  check the output of the job steps and post back details

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

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