When you are performing the SQL backup, below error comes out,
Backup failed for Server xxx. (Microsoft.SqlServer.SmoExtended)
Cannot open backup device ‘xxx’. Operating system error 5(Access is denied)
Solution
You may refer to the following solutions,
- Ensure the SQL service user is having the permissions to perform the backup to the target folder.
- Un-checked the Read-only attribute.
