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!
- This topic was modified 2 months ago by rjjh78.