September 30, 2021 at 4:07 pm
Hello,
I have been struggling trying to determine why I get the message "Cannot open backup device ''. Operating system error 5(Access is denied.)" when attempting to BackUp my database onto another network drive. I have made sure our SQL Service account has full permission to the drive which is not working. However, when doing a quick test with EVERYONE permissions it DOES work.
Here is what my code looks like:
BACKUP DATABASE [T2DKLR] TO DISK = N'\\UNCPATH\dbname.bak' WITH NOFORMAT, NOINIT,
NAME = N'dbname', SKIP, REWIND, NOUNLOAD, STATS = 10
Is there any other folder permissions I need to consider?
Many thanks in advance!
September 30, 2021 at 5:17 pm
The account running the SQL service needs read/write permissions to your share as well as read/write permissions on the disk.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy