Logshipping copy job failure

  • SQLisAwe5oMe

    SSChampion

    Points: 13851

    Hi Team,
    I am trying to setup logshipping from PROD to DR, and my copy job fails with following error.

    2018-01-14 08:15:14.12    Retrieved copy settings. Primary Server: 'Servername\InstanceName', Primary Database: 'DatabaseName', Backup Source Directory: '\\ServerName\LogShip_Backup', Backup Destination Directory: 'F:\LogShip_Backup', Last Copied File: '<None>'
    2018-01-14 08:15:14.13    Copying log backup files. Primary Server: 'Servername\InstanceName', Primary Database: 'DatabaseName', Backup Source Directory: '\\ServerNameL\LogShip_Backup', Backup Destination Directory: 'F:\LogShip_Backup'
    2018-01-14 08:15:14.17    *** Error: Access to the path '\\ServerNameL\LogShip_Backup' is denied.(mscorlib) ***

    I have provide read/write to the share for SQL Service acct from DR(Secondary) server, so, not sure what other acct should be added to share?

    Any thoughts on this plz.

    Regards,
    SQLisAwe5oMe.

  • SQL!$@w$0ME

    SSChampion

    Points: 12343

    Did you check if the agent service account on dr server has read/write access on the shares(back up and copy directories). Check share security properties. Just try to manually access the folders from dr sql server. Use server name or IP address.

  • SQL!$@w$0ME

    SSChampion

    Points: 12343

    Just use the above steps as a starting point.

  • SQLisAwe5oMe

    SSChampion

    Points: 13851

    SQL!$@w$0ME - Sunday, January 14, 2018 11:13 AM

    Did you check if the agent service account on dr server has read/write access on the shares(back up and copy directories). Check share security properties. Just try to manually access the folders from dr sql server. Use server name or IP address.

    Thanks....when I double check, I noticed SQL Server agent was running under different service acct, so I added that as well to the share security and now it's working.
    Thanks again.

    Regards,
    SQLisAwe5oMe.

  • Perry Whittle

    SSC Guru

    Points: 233678

    SQLisAwE5OmE - Monday, January 15, 2018 1:06 PM

    SQL!$@w$0ME - Sunday, January 14, 2018 11:13 AM

    Did you check if the agent service account on dr server has read/write access on the shares(back up and copy directories). Check share security properties. Just try to manually access the folders from dr sql server. Use server name or IP address.

    Thanks....when I double check, I noticed SQL Server agent was running under different service acct, so I added that as well to the share security and now it's working.
    Thanks again.

    you need to ensure the account is added to share and ntfs permission sets

    -----------------------------------------------------------------------------------------------------------

    [font="Tahoma"]"Ya can't make an omelette without breaking just a few eggs"[/font] 😉

Viewing 5 posts - 1 through 5 (of 5 total)

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