In Log shipping Copy Job is not Running successfully...

  • Could be the permission issue. Any error in SQL log?

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

  • firstly check permissions to the backup share location where the log backups are to be copied from. The sql server agent service on the LS secondary will need permission to access the files.

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

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

  • Hi Jagdeesh,

    Have you got the solution? I am also getting the same error. Pl help me out

  • sinthanaisirpi.k (5/9/2014)


    Hi Jagdeesh,

    Have you got the solution? I am also getting the same error. Pl help me out

    Have you checked permissions to the primary backup share for the secondarys sql agent account

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

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

  • Resolved.

    Permissions are fine.

    The problem is with the SQLLogShip.exe in

    drive:\Program Files\Microsoft SQL Server\100\Tools\Binn\

    So i replaced with another exc. Now it is working fine.

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

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