Restore Job is running Successfully But the Data Restoring is happening Second Successful Run

  • Dear All,

    I have Configured Log Shipping in 2008 successfully.

    But Restoring is not happening properly.

    The thing is that i have scheduled the Restore Job for every 5 min it is running successfully But Data is not Restoring which i have inserted in Primary DB,After running the Restoring Job second time it means that 10th min the data is restoring successfully in the secondary database.Even if i run the Job manually within 5 min the data is restoring successfully.

    PFA.....

    Regards

    Jagadeesh...

    Regards
    Chowdary...

  • This is normal and happen when your backpu/copy from primary to secondary will take more than 5 min. So restore job on secondary will not find any file to restore but nextime it will do.

    HTH

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

Viewing 2 posts - 1 through 1 (of 1 total)

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