April 14, 2014 at 10:42 pm
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...
April 15, 2014 at 1:41 am
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."
April 16, 2014 at 5:09 am
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" 😉
May 9, 2014 at 5:24 am
Hi Jagdeesh,
Have you got the solution? I am also getting the same error. Pl help me out
May 9, 2014 at 6:49 am
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" 😉
May 9, 2014 at 6:53 am
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