none
LS_Copy & LS_Restore job not working in Log shipping MS SQL 2016 RRS feed

  • Question

  • Hello Everyone,

    Trying to configure Log shipping as DR solution. LS_Backup working fine in primary site. Backup files are getting resides in primary. However, LS_Copy & LS_Restore jobs are getting failed. Observed that backupfiles are not available or not copied to destination folder.

    Need help in this regards.

    --- COPY Job log:

    Date 9/25/2019 11:06:53 PM
    Log Job History (LSCopy_BC-DB_Simulator)

    Step ID 1
    Server BC-DR\DRDB
    Job Name LSCopy_BC-DB_Simulator
    Step Name Log shipping copy job step.
    Duration 00:00:00
    Sql Severity 0
    Sql Message ID 0
    Operator Emailed
    Operator Net sent
    Operator Paged
    Retries Attempted 0

    Message
    Executed as user: NT Service\SQLAgent$DRDB. The step failed.

    -- Restore Job

    Date 9/25/2019 11:15:00 PM
    Log Job History (LSRestore_BC-DB_Simulator)

    Step ID 1
    Server BC-DR\DRDB
    Job Name LSRestore_BC-DB_Simulator
    Step Name Log shipping restore log job step.
    Duration 00:00:00
    Sql Severity 0
    Sql Message ID 0
    Operator Emailed
    Operator Net sent
    Operator Paged
    Retries Attempted 0

    Message
    Executed as user: NT Service\SQLAgent$DRDB. The step failed.

    *** for security purpose --- renamed domain name and db name

    • Edited by SinuDBA Wednesday, September 25, 2019 8:45 PM
    Wednesday, September 25, 2019 8:24 PM

All replies

  • Hi SinuDBA,

    From your description, did your shared backup folder is located on the primary server? Did you give the read permission for the shared backup folder to your SQL server Agent service account for the secondary server instance. If I misunderstood, please let me know. Which account is that your SQL server service is running under? You can use Local system account  or domain account.  Please make sure your SQL server agent and SQL server browser is running, the TCP\IP protocol is enabled.

    Please also follow steps from below document to check if you missed something. Please refer to Configure Log Shipping (SQL Server).

    Best regards,
    Cathy 

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Thursday, September 26, 2019 6:49 AM
  • Hello Cathy,

    Did your shared backup folder is located on the primary server? --- Yes

    Did you give the read permission for the shared backup folder to your SQL server Agent service account for the secondary server instance. --- Yes. Now I changed from NT services to domain name user.

    Which account is that your SQL server service is running under?  ---- domain\username

    Please make sure your SQL server agent and SQL server browser is running, the TCP\IP protocol is enabled.  --- YES

    Even though.. no luck 



    • Edited by SinuDBA Thursday, September 26, 2019 12:37 PM
    Thursday, September 26, 2019 9:13 AM
  • Hi SinuDBA,

    Did your domain\user is member in the sysadmin fixed server role? 

    Best regards,
    Cathy 

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Friday, September 27, 2019 1:28 AM
  • Hi Cathy,

    Yes.. user has sysadmin role.

    Friday, September 27, 2019 3:40 AM
  • Hi SinuDBA,

    According to log job history,  it seems a permission issue. But we have checked this is not the reason case the issue.  So could you please check your SQL server log job history again  to find more detail error information? Or could you please  try to find some related error information from SQL server error log?

    Best regards,
    Cathy 

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Monday, September 30, 2019 1:38 AM