Results 1 to 2 of 2
  1. #1
    Join Date
    May 2016
    Posts
    1

    Question Unanswered: Log Shipping Copy Job Not working as on time which specified

    Hi All,

    I am using SQL Server 2005.

    I am taking backup of my Live Server to another local server by using transnational log shipping.

    On Secondary there are two jobs 1) LS Copy 2) LS Restore

    To LS Copy I have scheduled for after every 15 minutes It will take action.

    To LS Restore I have scheduled for after every 60 minutes It will take action.

    LS Restore is working fine...

    But LS Copy Not working as specified. Eg: It ran on 4:15 AM, then 9:45 AM then 11:00 AM.


    So can any one give me the reasons what is happening and why LS Copy not working after every 15 minutes.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    What errors appear in your LS Copy job's Log History?

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •