SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Copy Job is not working in Log_shipping


Copy Job is not working in Log_shipping

Author
Message
Chowdary's
Chowdary's
Mr or Mrs. 500
Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)

Group: General Forum Members
Points: 592 Visits: 566
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...
Beatrix Kiddo
Beatrix Kiddo
SSCertifiable
SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)

Group: General Forum Members
Points: 6811 Visits: 4830
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.
Chowdary's
Chowdary's
Mr or Mrs. 500
Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)

Group: General Forum Members
Points: 592 Visits: 566
Hi Sir,

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

Regards
Chowdary...
Beatrix Kiddo
Beatrix Kiddo
SSCertifiable
SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)

Group: General Forum Members
Points: 6811 Visits: 4830
Two questions;

1) is there anything in the error log?

2) Does the Service Account have permission to write to the destination folder?
tim_harkin
tim_harkin
SSChasing Mays
SSChasing Mays (621 reputation)SSChasing Mays (621 reputation)SSChasing Mays (621 reputation)SSChasing Mays (621 reputation)SSChasing Mays (621 reputation)SSChasing Mays (621 reputation)SSChasing Mays (621 reputation)SSChasing Mays (621 reputation)

Group: General Forum Members
Points: 621 Visits: 925
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.
Chowdary's
Chowdary's
Mr or Mrs. 500
Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)

Group: General Forum Members
Points: 592 Visits: 566
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...
Beatrix Kiddo
Beatrix Kiddo
SSCertifiable
SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)

Group: General Forum Members
Points: 6811 Visits: 4830
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?
Beatrix Kiddo
Beatrix Kiddo
SSCertifiable
SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)

Group: General Forum Members
Points: 6811 Visits: 4830
(dup)
Chowdary's
Chowdary's
Mr or Mrs. 500
Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)

Group: General Forum Members
Points: 592 Visits: 566
Thnak U So Much Sir....

Regards
Chowdary...
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search