Error:
Cannot open backup device. Operating system error 5(Access is denied.)
BACKUP DATABASE is terminating abnormally.
Snap Shot:
Causes:
SQL service might not have permission to the Path where back up is supposed to be created.
Workaround:
- Connect to DATABASE with [SA] credentials.
- Assign SQL service permission to the backup path.