خرید بک لینک

Vote count: 0

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   -----

asked 48 secs ago

برچسب: نویسنده: استخدام کار تاريخ: يکشنبه 13 تير 1395 ساعت: 8:04

صفحه بندی