Database Back up Error: Operating system error 5(Access is denied.)

  • 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!

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