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

Copy Job is not working in Log_shipping Expand / Collapse
Author
Message
Posted Tuesday, April 15, 2014 3:46 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 5:55 AM
Points: 163, Visits: 524
Dear All,

I have configured the Log Shipping in 2008,
Backup Job is running but the Copy Job is not running ,
It Is throwing an Error like "Job Was Involked by User SA" .If I Expand that it is showing like Executed by User XXXX


Pls Help Me Out..

Regards
Jagadeesh


Regards
Chowdary...
Post #1561794
Posted Tuesday, April 15, 2014 4:40 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 8:09 AM
Points: 507, Visits: 1,867
Is this the same issue as in your previous thread? Try to keep it to one thread if you can.

Please post the whole error message.
Post #1561803
Posted Tuesday, April 15, 2014 4:53 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 5:55 AM
Points: 163, Visits: 524
Hi Sir,

Please Find the Below Error message
Message
Executed as user: MERIX-PC\SYSTEM. The step failed.


Regards
Chowdary...
Post #1561805
Posted Tuesday, April 15, 2014 5:24 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 8:09 AM
Points: 507, Visits: 1,867
Two questions;

1) is there anything in the error log?

2) Does the Service Account have permission to write to the destination folder?
Post #1561813
Posted Tuesday, April 15, 2014 5:48 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 12:44 PM
Points: 250, Visits: 698
Jagadeesh Chowdary (4/15/2014)
Hi Sir,

Please Find the Below Error message
Message
Executed as user: MERIX-PC\SYSTEM. The step failed.


Looks like your SQL Agent service is not using a domain account, but the local system account. The account that the SQL agent job uses needs to have permissions to write to the destination where the backups are shipped to.
Post #1561819
Posted Tuesday, April 15, 2014 6:05 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 5:55 AM
Points: 163, Visits: 524
Hi Sir,
Here the SQL Server Agents are running under LocalSystem Service account only,
Where should i check whether the permissions are there or not for that particular service account,

Note:
Here My system Primary Server is running under the account as NT Authority\LocalService and Secondary Server is running under the account as Localsystem Account,Is there any issue in that.

There was no Error in error Log

Please give me some suggestions for that


Regards
Chowdary...
Post #1561830
Posted Tuesday, April 15, 2014 8:02 AM This worked for the OP Answer marked as solution
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 8:09 AM
Points: 507, Visits: 1,867
Normally I'd say do this;

The place you want to copy the log backups to; right-click on the folder > Properties > Security and see if the Service Account has permissions there. If not, grant it permissions.

HOWEVER it looks as though you are using an account that is local to your machine so that won't work; you need to use an account with domain privileges for this or you won't be able to set up log-shipping to another machine or server.

Do you have a Windows sysadmin there who can help you?
Post #1561885
Posted Tuesday, April 15, 2014 8:02 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 8:09 AM
Points: 507, Visits: 1,867
(dup)
Post #1561886
Posted Wednesday, April 16, 2014 12:57 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 5:55 AM
Points: 163, Visits: 524
Thnak U So Much Sir....

Regards
Chowdary...
Post #1562147
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse