none
log shipping copy job fail

    Question

  • step1:

    Step ID 1
    Server machine name
    Job Name LSCopy
    Step Name Log shipping copy job step.
    Duration 00:00:01
    Sql Severity 0
    Sql Message ID 0
    Operator Emailed
    Operator Net sent
    Operator Paged
    Retries Attempted 0

    Message
    2018-04-30 09:10:01.31 Copying log backup files. Primary Server: 'sql instance', Primary Database: 'db name', Backup Source Directory: '\\primary path', Backup Destination Directory: '\\secondary path'

    step2:

    Date 4/30/2018 9:10:00 AM
    Log Job History (LSCopy)

    Step ID 1
    Server machine name
    Job Name LSCopy
    Step Name Log shipping copy job step.
    Duration 00:00:02
    Sql Severity 0
    Sql Message ID 0
    Operator Emailed
    Operator Net sent
    Operator Paged
    Retries Attempted 0

    Message
    2018-04-30 09:10:01.95 *** Error: The user name or password is incorrect.
    (mscorlib) ***
    2018-04-30 09:10:02.00 ----- END OF TRANSACTION LOG COPY     -----

    Exit Status: 1 (Error)


    step3:

    Date 4/30/2018 9:10:00 AM
    Log Job History (LSCopy)

    Step ID 1
    Server machine name
    Job Name LSCopy
    Step Name Log shipping copy job step.
    Duration 00:00:02
    Sql Severity 0
    Sql Message ID 0
    Operator Emailed
    Operator Net sent
    Operator Paged
    Retries Attempted 0

    Message
    Executed as user: machinename\dbadmin. The step failed.


    can anyone suggest me what is the issue
    Friday, April 27, 2018 5:54 AM

All replies

  • What is service account of agent, did you recently changed its password. Any other error in job history please look closely and post here. Where are you copying the files on fileshare or on seocndary database directly

    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP

    Friday, April 27, 2018 6:52 AM