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

• rjjh78

  SSCrazy

  Points: 2787

  More actions

  September 30, 2021 at 4:07 pm

  #3935132

  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 3 years, 8 months ago by rjjh78.

• Ant-Green

  SSC Guru

  Points: 113544

  More actions

  September 30, 2021 at 5:17 pm

  #3935168

  The account running the SQL service needs read/write permissions to your share as well as read/write permissions on the disk.