blocks|key|3438082|text|Server服务帐户没有写入文件夹C:\Users\Kimpoy\Desktop\Backup\的权限|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3438083|entityMap^0|H|V|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

The SQL Server service account does not have permissions to write to the folder <code>C:\Users\Kimpoy\Desktop\Backup\</code>

blocks|key|1676219|text|我也有过类似的问题。我向.bak文件本身添加了写权限，我的文件夹是为网络服务用户编写备份的。要添加权限，只需右键单击要更改的文件/目录，请选择“安全”选项卡，并在其中添加适当的用户/权限。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1676220|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

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.

blocks|key|1676245|text|是的，我刚得了这个。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1676246|查看Windows服务。启动>管理>服务|1676247|在名为:MSSQLSERVER+(MSSQLSERVER)的列表中查找“look+As”列(如果列表中不存在它，则需要添加它)。|1676248|这是您需要为目录授予权限的帐户，右键单击资源管理器>属性>共享(和安全性)|1676249|注意：如果您要穿越网络，请记住将权限授予实际目录和共享。|offset|length|style|BOLD|1676250|应用并等待权限转发，再次尝试备份。|1676251|备注2：如果您正在通过网络进行备份，并且您的SQL正在作为“本地服务”运行，那么您就有麻烦了.您可以尝试分配权限，或者在Server之外(一小时后)进行本地备份和xcopy操作可能会更容易。|1676252|注释3：如果您作为网络服务运行，那么远程计算机有时将无法识别Server上的网络序列化。如果是这种情况，则需要为实际计算机本身添加权限。我的服务器。|1676253|entityMap^0|0|0|0|0|0|2|0|0|0|3|0|0|3|0^^$0|@$1|2|3|4|5|6|7|V|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|W|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|X|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|Y|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|Z|8|@$J|10|K|11|L|M]]|9|@]|A|$]]|$1|N|3|O|5|6|7|12|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|13|8|@$J|14|K|15|L|M]]|9|@]|A|$]]|$1|R|3|S|5|6|7|16|8|@$J|17|K|18|L|M]]|9|@]|A|$]]|$1|T|3|-4|5|6|7|19|8|@]|9|@]|A|$]]]|U|$]]

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$.

blocks|key|3438164|text|转到开始菜单中的SQL+server文件夹，然后单击configuration选择Server服务上的server配置管理器，在所需的实例上将(Log+as)更改为本地系统|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3438165|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

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

blocks|key|1676340|text|最近我也遇到了这个问题，但是我从服务器A运行备份作业，但是备份的数据库位于服务器B上的服务器C上的文件共享上。当服务器A上的代理告诉服务器B运行备份that命令时，它实际上是sql在服务器B上运行的服务帐户，试图将备份写入服务器C。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1676341|请记住，它是执行实际备份数据库命令的sql服务器的服务帐户，它需要文件系统上的特权，而不是代理。|1676342|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

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.

blocks|key|3438220|text|我也有过同样的问题，下面的网址对我很有帮助。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3438221|这也可能对你有帮助。|3438222|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/|offset|length|3438223|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|0|42|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|Q|8|@]|9|@$F|R|G|S|1|T]]|A|$]]|$1|H|3|-4|5|6|7|U|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|E]]]]

I had the same issue and the url below really helped me.

It might help you as well.

<a href="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/" rel="nofollow">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/</a>

blocks|key|1676391|text|Msg+3201，级别16，状态1，行1不能打开备份设备'C:\+backup+\Adventure_20120720_1024AM.trn‘。操作系统错误5(访问被拒绝)。Msg+3013，16级，状态1，第1行备份日志正在异常终止。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1676392|我在C驱动器上验证了备份文件夹，新的服务帐户是否具有完全控制访问权限?我意识到"Test\Kiran“服务帐户没有完全控制安全权限。|1676393|请按照以下步骤对服务帐户进行全面控制：|1676394|1676395|转到C驱动器，右键单击备份文件夹。|ordered-list-item|1676396|选择安全选项卡。|1676397|点击编辑按钮，新窗口将打开。|1676398|单击“添加”按钮，然后输入“测试\Kiran用户帐户”并单击“检查名称”按钮，这将验证您输入的用户是否存在，如果它已存在，则将显示用户在窗口上，选择“确定”。|1676399|“选择您输入的用户名”并在“允许”下选中“完全控制”复选框。|1676400|1676401|entityMap^0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|W|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|X|8|@]|9|@]|A|$]]|$1|G|3|H|5|I|7|Y|8|@]|9|@]|A|$]]|$1|J|3|K|5|I|7|Z|8|@]|9|@]|A|$]]|$1|L|3|M|5|I|7|10|8|@]|9|@]|A|$]]|$1|N|3|O|5|I|7|11|8|@]|9|@]|A|$]]|$1|P|3|Q|5|I|7|12|8|@]|9|@]|A|$]]|$1|R|3|-4|5|6|7|13|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|14|8|@]|9|@]|A|$]]]|T|$]]

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:

<ol>
<li>Go to C drive, Right click on Backup folder. </li>
<li>Select Security tab. </li>
<li>Click on Edit button, new window will open. </li>
<li>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.</li>
<li>Select you entered user name and select Full Control check box under allow.</li>
</ol>

blocks|key|3398206|text|请检查对drives.First的访问权限，创建一个文件夹并转到文件夹属性，|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3398207|您可以找到“安全”选项卡，单击该选项卡，检查您的用户标识是否具有访问权限。|3398208|如果找不到您的id，请单击“添加”按钮，并提供具有完全访问权限的用户名。|3398209|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

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.

blocks|key|1676463|text|我自己也在经历这个。我已经确保了我的MSSQLSERVER登录用户有full+access，但它仍然会导致问题。只有当我将目的地移到C的根目录(更重要的是，从用户文件夹中移出)(即使我有一个具有完全权限的共享--甚至尝试过“每个人”作为测试)时，它才起作用。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1676464|我不知道我是否认为我的问题“固定”，但它是“工作”。|1676465|只是一个FYI的任何其他用户遇到这个线程。|1676466|entityMap^0|Y|B|0|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@$9|M|A|N|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|O|8|@]|D|@]|E|$]]|$1|H|3|I|5|6|7|P|8|@]|D|@]|E|$]]|$1|J|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|K|$]]

I was just going through this myself. I had ensured that my MSSQLSERVER login user had <code>full access</code> 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.

blocks|key|1676497|text|我知道这不是一个确切的解决方案，但使用外部驱动路径解决了这个问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1676498|BACKUP+DATABASE+AcinsoftDB
TO+DISK+=+'E:\MyDB.Bak'
WITH+FORMAT,
MEDIANAME+=+'C_SQLServerBackups',
NAME+=+'Full+Backup+of+MyDB';|code-block|syntax|javascript|1676499|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I know it is not an exact solution but using external drive paths solves this problem.

<pre><code>BACKUP DATABASE AcinsoftDB
TO DISK = 'E:\MyDB.Bak'
WITH FORMAT,
MEDIANAME = 'C_SQLServerBackups',
NAME = 'Full Backup of MyDB';
</code></pre>

blocks|key|1676510|text|我在Windows10上的2014+SP1也面临着同样的问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1676511|有效的解决方案|1676512|通过键入Services|1676513|Locate并打开Server+(SQLExpress)|unordered-list-item|1676514|
|1676515|Go到LogOn+Tab+|1676516|1676517|，选择本地系统帐户(还检查是否允许服务与桌面进行交互)|1676518|1676519|单击OK。停止服务。重新启动服务。|1676520|1676521|问题解决了|1676522|1676523|entityMap^0|0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Z|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|10|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|11|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|12|8|@]|9|@]|A|$]]|$1|K|3|L|5|H|7|13|8|@]|9|@]|A|$]]|$1|M|3|J|5|6|7|14|8|@]|9|@]|A|$]]|$1|N|3|O|5|H|7|15|8|@]|9|@]|A|$]]|$1|P|3|J|5|6|7|16|8|@]|9|@]|A|$]]|$1|Q|3|R|5|H|7|17|8|@]|9|@]|A|$]]|$1|S|3|J|5|6|7|18|8|@]|9|@]|A|$]]|$1|T|3|U|5|H|7|19|8|@]|9|@]|A|$]]|$1|V|3|-4|5|6|7|1A|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|1B|8|@]|9|@]|A|$]]]|X|$]]

I face the same problem with SQL Express 2014 SP1 on Windows 10.

Solution which work 

<ol>
<li>Open Service by typing Services</li>
<li>Locate and open the SQL Server (SQLExpress)</li>
<li>Go to the LogOn Tab </li>
<li>Choose Local System Account ( Also Check for Allow Services to interact with desktop )</li>
<li>Click OK . Stop the service . Restart the service. </li>
<li>Problem solved</li>
</ol>

blocks|key|1676537|text|这是我过去对这个问题所做的事。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1676538|1)到后援|1676539|2)删除到磁盘的目标文件路径。|1676540|3)点击Add|1676541|4)在“文件名：”复选框中，在..\backup后手动键入备份名称，如下所示，其中Yourdb.bak是数据库备份名称|1676542|C:\Program+\Microsoft+Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\Yourdb.bak|1676543|5)点击OK|1676544|希望这能有所帮助！|1676545|entityMap^0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|U|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|V|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|W|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|X|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|Y|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|Q|$]]

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!

blocks|key|3398317|text|共享此文件夹并使用UNC路径，例如：\pc\backups\mydb.bak|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3398318|那你就可以停止分享了。|3398319|不太优雅，但它解决了所有权限问题(您也需要给出共享的权限，如前所述)|3398320|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

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)

blocks|key|3438434|text|当.BAK文件临时存储在一个用BitLocker加密的文件夹中时，我就遇到了这个问题。它在移动到另一个文件夹后保留了加密。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3438435|网络服务帐户无法解密该文件，并提供了这条信息丰富的错误消息。|3438436|删除BitLocker加密(通过取消检查文件属性中的“加密内容以保护数据”)解决了这个问题。|3438437|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

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.

blocks|key|1676634|text|嗨，您需要将查询更改为：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1676635|BACKUP+DATABASE+AcinsoftDB
TO+DISK+=+'C:\Users\Me\Desktop\Backup\MyDB.Bak'|code-block|syntax|javascript|1676636|至|1676637|BACKUP+DATABASE+AcinsoftDB
TO+DISK+=+N'C:\Users\Me\Desktop\Backup\MyDB.Bak'|1676638|你必须在这条路前面加上一个N，这条路对我很有用。|1676639|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

Hi you need to change the query from: 

<pre><code>BACKUP DATABASE AcinsoftDB
TO DISK = 'C:\Users\Me\Desktop\Backup\MyDB.Bak'
</code></pre>

to 

<pre><code>BACKUP DATABASE AcinsoftDB
TO DISK = N'C:\Users\Me\Desktop\Backup\MyDB.Bak'
</code></pre>

You have to add a N in front of the path works for me.

blocks|key|1676650|text|我也有同样的错误。下面的更改帮助我解决了这个问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1676651|1676652|+I必须检查Server+>Tool->Services，并为服务找到用户(“登录为”列)：Server+(SQLEXPRESS)。|blockquote|1676653|1676654|我转到本地文件夹(C:\Users\Me\Desktop\Backup)并添加了"NT+Service\MSSQL$SQLEXPRESS“作为用户，以授予写权限。|1676655|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|L|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|M|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|N|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|P|8|@]|9|@]|A|$]]]|J|$]]

I have the same error. Following changes helped me to fix this.

<blockquote>
 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.
</blockquote>

blocks|key|1676760|text|为了找出您需要授予进行还原过程的权限的用户，可以执行以下步骤：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1676761|您需要转到安装server的服务器。查找Server配置管理器|1676762|​|1676763|📷|atomic|offset|length|1676764|1676765|接下来，您需要转到“Server服务”|1676766|1676767|1676768|1676769|在您的MSSQLSERVER+(MSSQLSERVER)实例下，将有一个列为"Logon“的帐户，在我的示例中是NT服务\MSSQLSERVER。|style|BOLD|1676770|这是您需要在源.bak位置的Security下添加的帐户，并授予该用户"+read“权限，以便可以读取备份文件。|1676771|假设您的备份文件存在于"D:\Shared“文件夹中，那么您需要提供如下权限：|1676772|1676773|1676774|1676775|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://developer.qcloudimg.com/http-save/yehe-900000/c4b7035efe846728de2036c901ccab53.png|imageAlt|1|https://developer.qcloudimg.com/http-save/yehe-900000/90b7926a1198c8e4aa087716835272d0.png|2|https://developer.qcloudimg.com/http-save/yehe-900000/8da48211b89b071dd15c3f5d05979be2.png^0|0|0|0|0|1|0|0|0|0|0|0|1|1|0|0|1K|G|0|0|0|0|0|1|2|0|0^^$0|@$1|2|3|4|5|6|7|1E|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1F|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|1G|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|1H|8|@]|9|@$I|1I|J|1J|1|1K]]|A|$]]|$1|K|3|E|5|6|7|1L|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|1M|8|@]|9|@]|A|$]]|$1|N|3|E|5|6|7|1N|8|@]|9|@]|A|$]]|$1|O|3|G|5|H|7|1O|8|@]|9|@$I|1P|J|1Q|1|1R]]|A|$]]|$1|P|3|E|5|6|7|1S|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1T|8|@$I|1U|J|1V|S|T]]|9|@]|A|$]]|$1|U|3|V|5|6|7|1W|8|@]|9|@]|A|$]]|$1|W|3|X|5|6|7|1X|8|@]|9|@]|A|$]]|$1|Y|3|E|5|6|7|1Y|8|@]|9|@]|A|$]]|$1|Z|3|G|5|H|7|1Z|8|@]|9|@$I|20|J|21|1|22]]|A|$]]|$1|10|3|E|5|6|7|23|8|@]|9|@]|A|$]]|$1|11|3|-4|5|6|7|24|8|@]|9|@]|A|$]]]|12|$13|$5|14|15|16|A|$17|18|19|-4]]|1A|$5|14|15|16|A|$17|1B|19|-4]]|1C|$5|14|15|16|A|$17|1D|19|-4]]]]

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

<a href="https://i.stack.imgur.com/HXETx.png" rel="noreferrer"><img src="https://i.stack.imgur.com/HXETx.png" alt="enter image description here"></a>

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

<a href="https://i.stack.imgur.com/5HSvX.png" rel="noreferrer"><img src="https://i.stack.imgur.com/5HSvX.png" alt="enter image description here"></a>

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:

<a href="https://i.stack.imgur.com/o1jsG.png" rel="noreferrer"><img src="https://i.stack.imgur.com/o1jsG.png" alt="enter image description here"></a>

blocks|key|3438700|text|发生这种情况的原因之一是，您正在运行MSSQLSERVER服务，而不使用本地系统。若要解决此问题，请使用以下步骤。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3438701|使用(MSSQLSERVER)|3438702|Right+%2B+R|unordered-list-item|3438703|
|3438704|Type+services.msc打开运行，服务对话框将打开|3438705|3438706|查找MSSQLSERVER|3438707|3438708|services.msc并单击属性。|3438709|3438710|转到登录选项卡|3438711|
选择本地系统帐户并单击“应用”和“确定”<代码>H+212<>H+113单击左侧面板上的停止链接，选择“MSSQLSERVER+(MSSQLSERVER)”并再次完全启动备份。H+216G+217|offset|length|style|CODE|3438712|希望它能帮到你，就像它对我一样。干杯!|3438713|entityMap^0|0|0|0|0|0|0|0|0|0|0|0|2H|A|0|0^^$0|@$1|2|3|4|5|6|7|13|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|14|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|15|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|16|8|@]|9|@]|A|$]]|$1|I|3|J|5|F|7|17|8|@]|9|@]|A|$]]|$1|K|3|H|5|6|7|18|8|@]|9|@]|A|$]]|$1|L|3|M|5|F|7|19|8|@]|9|@]|A|$]]|$1|N|3|H|5|6|7|1A|8|@]|9|@]|A|$]]|$1|O|3|P|5|F|7|1B|8|@]|9|@]|A|$]]|$1|Q|3|H|5|6|7|1C|8|@]|9|@]|A|$]]|$1|R|3|S|5|F|7|1D|8|@]|9|@]|A|$]]|$1|T|3|U|5|6|7|1E|8|@$V|1F|W|1G|X|Y]]|9|@]|A|$]]|$1|Z|3|10|5|6|7|1H|8|@]|9|@]|A|$]]|$1|11|3|-4|5|6|7|1I|8|@]|9|@]|A|$]]]|12|$]]

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. 

<ol>
<li>Open run using Windows + R</li>
<li>Type services.msc and a services dialog will open</li>
<li>Find SQL Server (MSSQLSERVER)</li>
<li>Right click and click on properties.</li>
<li>Go to Log on tab</li>
<li>Select Local System account and click on "Apply" and "OK"</li>
<li>Click on Stop link on the left panel by selecting the "SQL Server (MSSQLSERVER)" and Start it again once completely stopped.</li>
<li>Enjoy your backup.</li>
</ol>

Hope it helps you well, as it did to me. Cheers!

blocks|key|1676912|text|Server无法将备份访问(写入)到指定位置。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1676913|首先，您需要验证运行Sql服务器的服务帐户。这可以通过使用配置管理器或Services.msc来完成。|1676914|或|1676915|使用以下查询：|1676916|1676917|从sys.dm_server_services中选择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作为DSS；|blockquote|1676918|1676919|1676920|现在看一看列service_account并记下它。|1676921|转到您正在尝试接受backup.In的位置:+C:\Users\Me\Desktop\Backup|1676922|右击->属性->安全性->|1676923|添加服务帐户并提供读/写权限。这将解决这个问题。|1676924|entityMap^0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|X|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Y|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|Z|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|10|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|11|8|@]|9|@]|A|$]]|$1|I|3|J|5|K|7|12|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|13|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|14|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|15|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|16|8|@]|9|@]|A|$]]|$1|R|3|S|5|6|7|17|8|@]|9|@]|A|$]]|$1|T|3|U|5|6|7|18|8|@]|9|@]|A|$]]|$1|V|3|-4|5|6|7|19|8|@]|9|@]|A|$]]]|W|$]]

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 :

<blockquote>
<pre><code>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;
</code></pre>
</blockquote>

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.

blocks|key|3438823|text|在我的例子中，我忘记给备份文件命名，它一直给我提供相同的权限错误:/|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3438824|TO+DISK+N'{path}\WRITE_YOUR_BACKUP_FILENAME_HERE.bak'|code-block|syntax|javascript|3438825|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

In my case, I forgot to name the backup file and it kept giving me the same permission error :/

<pre><code>TO DISK N'{path}\WRITE_YOUR_BACKUP_FILENAME_HERE.bak'
</code></pre>

blocks|key|3438875|text|我用以下三个步骤解决了同样的问题：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3438876|3438877|I将备份文件存储在工作正常的其他文件夹路径中。|ordered-list-item|3438878|视图与安全选项卡的两个文件夹不同(如下图所示)。安全选项卡文件夹中的|3438879|编辑权限不能正常工作。|3438880|3438881|​|3438882|📷|atomic|offset|length|3438883|3438884|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://developer.qcloudimg.com/http-save/yehe-900000/e0f4185e22dc1d717e3e287d16da29f6.jpg|imageAlt^0|0|0|0|0|0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|11|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|12|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|13|8|@]|9|@]|A|$]]|$1|F|3|G|5|E|7|14|8|@]|9|@]|A|$]]|$1|H|3|I|5|E|7|15|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|16|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|17|8|@]|9|@]|A|$]]|$1|M|3|N|5|O|7|18|8|@]|9|@$P|19|Q|1A|1|1B]]|A|$]]|$1|R|3|L|5|6|7|1C|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|1D|8|@]|9|@]|A|$]]]|T|$U|$5|V|W|X|A|$Y|Z|10|-4]]]]

I solved the same problem with the following 3 steps:
<ol>
<li>I store my backup file in other folder path that's worked right.</li>
<li>View different of security tab two folders (as below image).</li>
<li>Edit permission in security tab folder that's not worked right.</li>
</ol>
<a href="https://i.stack.imgur.com/xZa0e.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/xZa0e.jpg" alt="enter image description here" /></a>

blocks|key|1677010|text|我的问题是，“文件所有权”设置为我的公司。我把它改成了“私人”，它起了作用。右键单击该文件并单击“文件所有权”选项，然后将其更改为"Personal“。我相信所有通过微软团队发送的文件都会发生这种情况。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1677011|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

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.

blocks|key|3398854|text|如果备份目标路径驻留在本地计算机上，请将“Server”服务的帐户更改为“”，则必须解决所有问题，请记住，“Server”实例服务负责访问备份目标，因此运行的帐户必须访问备份的目标路径。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3398855|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

If the backup destination path resides on your local machine, change the account of 'SQL Server' service to 'Local System Account', then everything must be resolved, keep in mind that the 'SQL Server' instance service is responsible to access the backup destination so the account it is running under, must have access to the destination path of your backup.

blocks|key|1677036|text|确保您实际上是保存到一个文件，而不是一个文件夹，|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1677037|我的问题是，我只是把文件夹路径，而不是文件路径|1677038|你想要这个|1677039|'F:\Database+Backup\Pharmacy\data.bak';|code-block|syntax|javascript|1677040|你不想这样|1677041|'F:\Database+Backup\Pharmacy';|1677042|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|S|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|T|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|U|8|@]|9|@]|A|$]]|$1|M|3|N|5|H|7|V|8|@]|9|@]|A|$I|J]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

Make sure you are actually saving to a FILE and not a folder,
My problem was I was simply putting in the Folder path and not the File path
You want this
<pre><code>'F:\Database Backup\Pharmacy\data.bak';
</code></pre>
You dont want this
<pre><code>'F:\Database Backup\Pharmacy';
</code></pre>

Below is the query that I am using to backup (create a <code>.bak</code>) my database. 

However, whenever I run it, I always get this error message:

<blockquote>
 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.
</blockquote>

This is my query:

<pre><code>BACKUP DATABASE AcinsoftDB
TO DISK = 'C:\Users\Me\Desktop\Backup\MyDB.Bak'
WITH FORMAT,
MEDIANAME = 'C_SQLServerBackups',
NAME = 'Full Backup of MyDB';
</code></pre>

Cannot open backup device. Operating System error 5

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

下面是用于备份(创建.bak)数据库的查询。但是，每当我运行它时，都会收到以下错误消息： Msg 3201，16级，状态1，第1行无法打开备份设备‘C：\用户\Me\桌面\备份\MyDB.Bak’。操作系统错误5(访问被拒绝)。Msg 3013，第16级，状态1，第1行备份数据库正在异常终止。这是我的疑问：BACKUP...

问无法打开备份设备。操作系统错误5
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问无法打开备份设备。操作系统错误5EN