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

  • He Experts...

    I have Configured Log shipping in SQL server 2008,

    Copy_Job is not running and throwing an error like the Following

    Message

    The job failed. The Job was invoked by User sa. The last step to run was step 1 (Log shipping copy job step.).

    If I Expand the Error then in the First step am getting the Below Error

    Message

    Executed as user: AMT173\SYSTEM. The step failed.

    Please Help Me Out..

    Regards

    Jagadeesh..

    Regards
    Chowdary...

  • 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 6 posts - 1 through 5 (of 5 total)

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