SQL DBA 81-Cannot Open Backup Device 'BackupLocationPath' Operating system error 5Access is denied
In this video you will learn to resolve an error " Cannot open backup device "backuplocation". Operating system error 5(Access is denied) or " Cannot open backup device "backuplocation". Operating system error 5(System cannot find path specified). Video shows multiple causes of above errors and how to resolve them step by step. Resolution include following fixes,
1- check to see if backup folder exists or path is valid in backup location parameter
2- Finding out SQL Server Service Account
3- Check to see if SQL Server Service Account has proper access (read, write, modify) on specified location
4- If job is running under proxy account, check to see if Proxy account has permission on backup location same as above permissions.
5- If SQL Server Agent is running the job and it is T-SQL Script, it is more likely that your SQL Server Service account doesn't have permission on backup location for Access denied issue.
Blog post link for the video with script
http://sqlage.blogspot.com/2015/04/ca...
Visit our website to check out SQL Server DBA Tutorial Step by Step
http://www.techbrothersit.com/2014/12...
On this page of the site you can watch the video online SQL DBA 81-Cannot Open Backup Device 'BackupLocationPath' Operating system error 5Access is denied with a duration of hours minute second in good quality, which was uploaded by the user TechBrothersIT 15 April 2015, share the link with friends and acquaintances, this video has already been watched 23,873 times on youtube and it was liked by 80 viewers. Enjoy your viewing!
