I'm having a problem with old Log files not being deleted after the retention period expires in a Log Shipping Job (Error Message Below)
The SQL Servers Service account obviously has access to the folder since it is able to create the backup files. I suspicion is that perhaps the delete part of the Job executes under the credentials of the SQL Agent rather than the credentials of the SQL Server Service. However I can't find any information to confirm this hypothesis.
2016-07-02 17:15:01.73 Deleting old log backup files. Primary Database: 'DBNAME'
2016-07-02 17:15:01.77 *** Error: Could not delete old log backup files.(Microsoft.SqlServer.Management.LogShipping) ***
2016-07-02 17:15:01.77 *** Error: Access to the path '\SERVERNAMELOGFILEBACKUPPATH' is denied.(mscorlib) ***
2016-07-02 17:15:01.78 The backup operation completed with errors. Primary Database: 'DBNAME', Log Backup File: '\SERVERNAMEPATHTOLOGGILE'
2016-07-02 17:15:01.79 ----- END OF TRANSACTION LOG BACKUP -----
