Error in ship transactional log

• manju.ccc

  SSC Eights!

  Points: 973

  More actions

  August 23, 2012 at 5:02 am

  #151051

  I'm trying to implement a ship transactional log between two servers. when the "copy" job run in my secondary server it gives the following error saying no permission to access my backup folder which is in my primary server. How to set the permission to both folders in both servers.

  Date8/23/2012 4:45:18 PM

  LogJob History (LSCopy_DBAHP_Test)

  Step ID 1

  Server BACKUPAHP

  Job NameLSCopy_DBAHP_Test

  Step NameLog shipping copy job step.

  Duration00:00:15

  Sql Severity0

  Sql Message ID0

  Operator Emailed

  Operator Net sent

  Operator Paged

  Retries Attempted 0

  Message

  2012-08-23 16:45:33.14Copying log backup files. Primary Server: 'DBAHP', Primary Database: 'Test', Backup Source Directory: '\\10.37.50.11\log', Backup Destination Directory: 'D:\Log2'

  2012-08-23 16:45:33.17

  *** Error: Access to the path '\\10.37.50.11\log' is denied.(mscorlib) ***

• Ant-Green

  SSC Guru

  Points: 113446

  More actions

  August 23, 2012 at 5:34 am

  #1529188

  need to grant the account which is running sql agent on the secondary server access to the share, or make the share available to everyone.