如何将SQL数据备份到Windows临时文件夹？ [英] How to backup SQL data to windows temp folder?

问题描述

HI，



我想将我的sql数据库备份到windows temp文件夹，当我使用ssms将sql数据库备份到windows temp路径时显示错误。 />


错误详情：

I want to backup my sql databse to windows temp folder, it shows error when i backup sql database using ssms to windows temp path.

error details:

TITLE: Microsoft SQL Server Management Studio
------------------------------

Backup failed for Server 'KGMMURUGESH\SQLEXPRESS'.  (Microsoft.SqlServer.SmoExtended)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=13.0.15600.2+((SSMS_Rel).160712-1724)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Backup+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: Cannot open backup device 'C:\Users\KGMMUR~1\AppData\Local\Temp'. Operating system error 5(Access is denied.). (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=13.0.15600.2+((SSMS_Rel).160712-1724)&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

我尝试过：



我尝试使用ssms和vb.net代码，它适用于其他一些文件夹。

What I have tried:

I tried using ssms and vb.net code, it works well for some other folders.

推荐答案

引用：

无法打开备份设备'C：\ Users \ KGMMUR~1 \ AppData\Local\Temp。操作系统错误5（访问被拒绝。）

Cannot open backup device 'C:\Users\KGMMUR~1\AppData\Local\Temp'. Operating system error 5(Access is denied.)

这意味着运行备份过程的用户没有该文件夹的访问权限...

检查备份作业，请参阅作业所有者的用户映射...

It means that the user running the backup process has no access rights to that folder...
Check the backup job an see the user mapping for the owner of the job...

这篇关于如何将SQL数据备份到Windows临时文件夹？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！