Post reply

log shipping copy and restore jobs

  • February 5, 2010 at 11:13 am

    #144764

    hi,

    my log shipping copy job was disabled and was last run in last month, but log shipping restore job was enabled and was running properly for each 15 minutes. How come it possible to restore without copying? Please suggest me

    Thanks

  • February 5, 2010 at 12:08 pm

    #1114698

    Scenario 1. If the primary server act as a secondary server and the Primaryserver backup and destination backup path are same then LS Copy is not required and you can keep it disabled.

    Scenario 2. If the LS Copy job disabled and if there is no files in the destination folder then LS Restore will succeed with doing nothing.

    Hope I answered your question.

    thanks

    Jay

    Thanks
    Jay
    http://www.sqldbops.com

  • February 5, 2010 at 12:15 pm

    #1114707

    Have you verified comparing the Database sizes of the Primary and the stand by database? If they are not nearly the same size, I would guess it is not restoring the T-Logs as Jay mentioned..

    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

  • February 5, 2010 at 1:49 pm

    #1114761

    You can verify the last backup file and last restore file by querying these table log_shipping_monitor_primary or log_shipping_monitor_secondary

    on either one of the servers primary or secondary on msdb database. So you know which was the last successful copy\restored file.

    EnjoY!

  • February 8, 2010 at 9:27 am

    #1115606

    Hi Jay,

    Thanks a lot. I think the Scenario 1 mentioned by you matches with my problem.

    Thanks to others also who replied for this post.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply