Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

In Log shipping Copy Job is not Running successfully... Expand / Collapse
Author
Message
Posted Monday, April 14, 2014 10:42 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 7:09 AM
Points: 83, Visits: 219
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..
Post #1561741
Posted Tuesday, April 15, 2014 1:41 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 2:56 AM
Points: 2,603, Visits: 2,061
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."
Post #1561772
Posted Wednesday, April 16, 2014 5:09 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:08 AM
Points: 6,162, Visits: 13,305
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"
Post #1562236
Posted Friday, May 9, 2014 5:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, May 9, 2014 11:28 AM
Points: 2, Visits: 4
Hi Jagdeesh,

Have you got the solution? I am also getting the same error. Pl help me out
Post #1569211
Posted Friday, May 9, 2014 6:49 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:08 AM
Points: 6,162, Visits: 13,305
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"
Post #1569238
Posted Friday, May 9, 2014 6:53 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, May 9, 2014 11:28 AM
Points: 2, Visits: 4
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.
Post #1569240
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse