This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 20%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJA%3C/text%3E%3C/svg%3E)
Greetings, I created an encrypted backup on our windows 2016 standard ed, with sql 2014 standard ed installed with the following options :
This worked fine, I was able to restore the database to another server, then I noticed a backup file copy job failing when it tried to access/copy this file. I have found that I can't remove this file now, when I right click and try to delete it does act as if it deletes the file but if you refresh the folder, it shows back up. When I right click the file and select the security tab it gives me a message "you must have read permissions to view the properties of this object. click advanced to continue". When I do that it shows under owner "unable to display the current owner". If I click change here, I get a message "you do not have permissions to view or edit the objects permission settings". I am a local admin on this machine.
Does anyone have any suggestions as to what to do/where to look further on what is going on here? I checked event viewer and I didn't see any errors when i "deleted" the file. Thanks for any reply.
Additional SQL Server features and topics not covered by specific categories
Answer accepted by question author
Hi @John Abel ,
Please check if below blog could help you.
Best regards,
Cathy
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Thanks Cathy, I used process explorer to find the file still in use, I have a SQL Agent job that runs a command file using robocopy to copy new files to a backup server and for some reason this started failing on that encrypted backup. There were 5 instances of robocopy still running which would probably be the same number of times that job was cancelled and reran which it appears when an agent job is cancelled and robocopy is in it's wait state trying to access a file, the robocopy process does not get terminated. using task manager I removed the robocopy processes, was able to delete the file. I ran another backup and my copy job process and everything is working as expected. Thanks
Hello, when I run that on the file i get an error "ERROR: Access is denied". I have run the command on a different file and it works with a "Success: .... " message
"Access is denied" can indicate lack of permissions - but it can also indicate that another process is locking the file.
In any case, this sounds more like a Windows question to me.
What is confusing me is how it happened? I simply created a backup on the server logged in as myself a local admin. I did grant specific access to the file for the sql server service account, but even that access has been modified. Now my account, the admins on the machine and the sql server service account only have read access. The only account that has full access is the server\admin account. If I can get access to that account or someone who can will see if they can delete it then I will try again and see if I can recreate the situation.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 1%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
I cannot find the reference, but I believe when you create an encrypted backup, only the SQL service account has access to the file, for security reasons. It does not mater who runs the command.
Use this to take ownership of the file.
https://learn.microsoft.com/en-us/windows-server/administration/windows-commands/takeown