Post reply

Copy Job is not working in Log_shipping

  • April 15, 2014 at 3:46 am

    #290254

    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...

  • April 15, 2014 at 4:40 am

    #1706030

    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.

  • April 15, 2014 at 4:53 am

    #1706032

    Hi Sir,

    Please Find the Below Error message

    Message

    Executed as user: MERIX-PC\SYSTEM. The step failed.

    Regards
    Chowdary...

  • April 15, 2014 at 5:24 am

    #1706038

    Two questions;

    1) is there anything in the error log?

    2) Does the Service Account have permission to write to the destination folder?

  • April 15, 2014 at 5:48 am

    #1706044

    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.

  • April 15, 2014 at 6:05 am

    #1706055

    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...

  • April 15, 2014 at 8:02 am

    #1706106

    (dup)

  • April 15, 2014 at 8:02 am

    #1706105

    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?

  • April 16, 2014 at 12:57 am

    #1706324

    Thnak U So Much Sir....

    Regards
    Chowdary...

Viewing 9 posts - 1 through 8 (of 8 total)

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