CODEWITHSUNDEEP
sql-serverdatabase-administrationlog-shipping
surya teja
surya teja

Reputation: 173

log shipping issue copy and restore jobs failed error access to the path is denied (mscorlib)

I have given access permission(sqlserveragent and mine) to the secondary folder but still I am getting this error. sql server : Ntservice\msssqlserver sql agent: domain\test

Message 2016-04-21 12:00:31.48 Starting transaction log copy. Secondary ID: 'bfa5d1ac-8c4c-4004-a1d1-27ab9a0bd6b4' 2016-04-21 12:00:31.49 Retrieving copy settings. Secondary ID: 'bfa5d1ac-8c4c-4004-a1d1-27ab9a0bd6b4' 2016-04-21 12:00:31.49 Retrieved copy settings. Primary Server: 'xxx', Primary Database: 'ac5T', Backup Source Directory: '\xx\Primaryshared', Backup Destination Directory: '\test\SecondaryShared', Last Copied File: '' 2016-04-21 12:00:31.51 Copying log backup files. Primary Server: 'CRYSTAL', Primary Database: 'ac5T', Backup Source Directory: '\xxx\Primaryshared', Backup Destination Directory: '\TEST\SecondaryShared' 2016-04-21 12:00:31.54 Copying log backup file to temporary work file. Source: '\xxx\Primaryshared\ac5T_20160421164404.trn', Destination: '\TEST\SecondaryShared\ac5T_20160421164404.wrk' 2016-04-21 12:00:31.56 *** Error: Access to the path '\TEST\SecondaryShared\ac5T_20160421164404.wrk' is denied.(mscorlib)

Upvotes: 0

Views: 3588

Answers (1)

itpro0918
itpro0918

Reputation: 51

I changed the user account of SQL Server Agent service to .\Administrator on secondary server only. And it resolved the issue. Please see the screenshot:

enter image description here

Upvotes: 0

Related Questions