Cannot open backup device Operating System error 5

Question

Below is the query that I am using to backup  create a  bak  my database    However  whenever I run it  I always get this error message      Msg 3201  Level 16  State 1  Line 1   Cannot open backup device  C  Users Me Desktop Backup MyDB Bak   Operating system error 5 Access is denied         Msg 3013  Level 16  State 1  Line 1   BACKUP DATABASE is terminating abnormally    This is my query   BACKUP DATABASE AcinsoftDB TO DISK    C  Users Me Desktop Backup MyDB Bak  WITH FORMAT  MEDIANAME    C SQLServerBackups   NAME    Full Backup of MyDB

User · Answer

In order to find out which user you need to give permission to do the restore process, you can follow the following steps:

You need to go to your server where SQL Server is installed. Find SQL Server Configuration Manager

Next, you need to go to "SQL Server Services"

Under your SQL Server (MSSQLSERVER) instance there will be an account with column "Logon As", in my case it is NT Service\MSSQLSERVER.

That is the account which you need to add under Security tab of your source .bak location and give that user the "Read" permissions so that the backup file can be read.

Let's say your backup file is present at "D:\Shared" folder, then you need to give permissions like this:

User · Answer

The SQL Server service account does not have permissions to write to the folder C  Users Kimpoy Desktop Backup

User · Answer

SQL Server is not able to access  write  the backup into the location specified   First you need to verify the service account on which the Sql server is running  This can be done by using Configuration manager or Services msc   or  Use below query     SELECT  DSS servicename      DSS startup type desc      DSS status desc      DSS last startup time      DSS service account      DSS is clustered      DSS cluster nodename      DSS filename      DSS startup type      DSS status      DSS process id FROM    sys dm server services AS DSS     Now look at the column service account and note it down   Go to the location where you are trying to take the backup In your case   C  Users Me Desktop Backup  Right click--  Properties --  Security --    Add the service account and provide read write permissions  This will resolve the issue

User · Answer

One of the reason why this happens is you are running your MSSQLSERVER Service not using a local system  To fix this issue  use the following steps     Open run using Windows   R Type services msc and a services dialog will open Find SQL Server  MSSQLSERVER  Right click and click on properties  Go to Log on tab Select Local System account and click on  Apply  and  OK  Click on Stop link on the left panel by selecting the  SQL Server  MSSQLSERVER   and Start it again once completely stopped  Enjoy your backup    Hope it helps you well  as it did to me  Cheers

User · Answer

Yeah I just scored this one    Look in Windows Services  Start   Administration   Services  Find the Service in the list called  SQL Server  MSSQLSERVER  look for the  Log On As  column  need to add it if it doesn t exist in the list    This is the account you need to give permissions to the directory  right click in explorer   properties   Shares  And Security   NOTE  Remember to give permissions to the actual directory AND to the share if you are going across the network   Apply and wait for the permissions to propogate  try the backup again   NOTE 2  if you are backing up across the network and your SQL is running as  Local Service  then you are in trouble     you can try assigning permissions or it may be easier to backup locally and xcopy across outside of SQL Server  an hour later    NOTE 3  If you re running as network service then SOMETIMES the remote machine will not recognize the network serivce on your SQL Server  If this is the case you need to add permissions for the actual computer itself eg  MyServer

User · Answer

Share this folder and use UNC path  by example   pc backups mydb bak  Then You can stop share   Not very elegant  but it resolves all permissions problems  You need to give permissions to share as well  as mentioned above

User · Answer

I had a similar issue  I added write permissions to the  bak file itself  and my folder that I was writing the backup to for the NETWORK SERVICE user  To add permissions just right-click what file directory you want to alter  select the security tab  and add the appropriate users permissions there

User · Answer

Msg 3201  Level 16  State 1  Line 1 Cannot open backup device  C  Backup Adventure 20120720 1024AM trn   Operating system error 5 Access is denied    Msg 3013  Level 16  State 1  Line 1 BACKUP LOG is terminating abnormally   I verified backup folder on C drive  Is new service account is having full control access permission or not   I realized that  Test Kiran  service account is not having Full control security permission   Please follow the below steps to give full control to service account    Go to C drive  Right click on Backup folder   Select Security tab   Click on Edit button  new window will open   Click on Add button and enter Test Kiran user account and click check name button  this will validate you entered user is existing or not  if it is existing it will show the user on window  select OK  Select you entered user name and select Full Control check box under allow

User · Answer

I face the same problem with SQL Express 2014 SP1 on Windows 10   Solution which work    Open Service by typing Services Locate and open the SQL Server  SQLExpress  Go to the LogOn Tab  Choose Local System Account   Also Check for Allow Services to interact with desktop   Click OK   Stop the service   Restart the service   Problem solved

User · Answer

I had this issue recently as well  however I was running the backup job from server A but the database being backed up was on server B to a file share on server C  When the agent on server A tells server B to run a backup t-sql command  its actually the service account that sql is running under on SERVER B that attempts to write the backup to server C   Just remember  its the service account of the sql server performing the actual BACKUP DATABASE command is what needs privileges on the file system  not the agent

User · Answer

Here is what I did to by-pass the issue   1  Go to backup  2  Remove the destination file-path to disk  3  Click on Add  4  In the File name  check box manually type in the backup name after    backup like below where Yourdb bak is the database backup name  C  Program Files Microsoft SQL Server MSSQL11 MSSQLSERVER MSSQL Backup Yourdb bak  5  Click on OK  Hope this helps

User · Answer

In my case  I forgot to name the backup file and it kept giving me the same permission error     TO DISK N  path  WRITE YOUR BACKUP FILENAME HERE bak

User · Answer

Hi you need to change the query from     BACKUP DATABASE AcinsoftDB TO DISK    C  Users Me Desktop Backup MyDB Bak    to   BACKUP DATABASE AcinsoftDB TO DISK   N C  Users Me Desktop Backup MyDB Bak    You have to add a N in front of the path works for me

User · Answer

I have the same error  Following changes helped me to fix this      I had to check Server Manager- Tool- Services and find the user   Log   On As  column  for service  SQL Server  SQLEXPRESS        I went to the local folder  C  Users Me Desktop Backup  and added  NT   Service MSSQL SQLEXPRESS  as the user to give Write permissions

User · Answer

My issue was that the  quot File Ownership quot  was set to my company  I changed it to  quot Personal quot  and it worked  Right click the file and click the  quot File Ownership  gt  quot  option and then change it to  quot Personal quot   I believe this happens with all files sent over Microsoft Teams

User · Answer

I was just going through this myself  I had ensured that my MSSQLSERVER login user had full access but it was still causing issues  It only worked once I moved the destination to the root of C  More importantly out of a user folder  even though I had a share with full permissions - even tried  Everyone  as a test    I don t know if i consider my issue  fixed   however it is  working    Just a FYI for any other users that come across this thread

User · Answer

I solved the same problem with the following 3 steps   I store my backup file in other folder path that s worked right  View different of security tab two folders  as below image   Edit permission in security tab folder that s not worked right

User · Answer

Go to the SQL server folder in start menu and click configuration tools Select SQL Server configuration manager On SQL server services  on the desired instance change the  Log On as  to local system

User · Answer

I experienced this problem when the  BAK file was temporarily stored in a folder encrypted with BitLocker  It retained the encryption after it was moved to a different folder   The NETWORK SERVICE account was unable to decrypt the file and gave this thoroughly informative error message   Removing BitLocker encryption  by unchecking  Encrypt contents to secure data  in the file properties  on the  BAK file resolved the issue

User · Answer

I know it is not an exact solution but using external drive paths solves this problem   BACKUP DATABASE AcinsoftDB TO DISK    E  MyDB Bak  WITH FORMAT  MEDIANAME    C SQLServerBackups   NAME    Full Backup of MyDB

User · Answer

Please check the access to drives First create one folder and go to folder properties    You may find the security tab  click on that check whether your user id having the access or not   if couldn t find the your id please click the add buttion and give user name with full access

User · Answer

I had the same issue and the url below really helped me   It might help you as well   http   blog sqlauthority com 2011 04 13 sql-server-fix-error-msg-3201-level-16-cannot-open-backup-device-operating-system-error-5access-is-denied

[sql-server-2008] Cannot open backup device. Operating System error 5

Examples related to sql-server-2008

Examples related to backup

Examples related to access-denied

Examples related to permission-denied