备份数据库-错误消息3201和3013 [英] Backup dataBase - Error msg 3201 ans 3013

问题描述

我需要从sql server 2008 management studio中备份数据库

我使用了以下查询

备份数据库DB1到磁盘=''Localpath \ db.bak''

这在本地服务器上工作正常，但是当我在服务器上执行相同的代码时
我收到错误消息，因为

消息3201，第16级，状态1，第1行
无法打开备份设备"D:\ DB.bak".操作系统错误5(访问被拒绝.).

消息3013，第16级，状态1，第1行
备份数据库异常终止.

请让我知道如何解决此问题...
在此先谢谢您

Hi,

I need to take an Back up of DB from sql server 2008 management studio

I used the below query

BACKUP DATABASE DB1 TO DISK=''Localpath\db.bak''

This works fine in local server, but when I execute the same code in server
I am getting error as

Msg 3201, Level 16, State 1, Line 1
Cannot open backup device ''D:\DB.bak''. Operating system error 5(Access is denied.).

Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.

Kindly let me know how to solve this issue...
Thanks in advance

推荐答案

请与托管SQL Server的ISP联系，他们应该可以执行此任务并为您提供对备份文件的访问权限

显然，您正在运行的命令在托管环境中将不起作用.允许客户在共享的托管环境中在您提到的位置中创建文件将是一个大问题，并且会引起各种问题！

取而代之的是，应该有某种可控的方式或文档来执行此操作，以在您的用户\站点\托管环境特定的位置创建文件.

Check with your ISP hosting the SQL Server, they should have a way of performing this task and providing you access to the backup file

Obviously, the commands you are running will not work in a hosted environment. Allowing customers to create files in the locations you''ve mentioned in a shared, hosted environment would be a massive issue and cause all sorts of problems!

Instead, there should be some sort of controlled way or documentation for you to do this that would create the file in a location specific to your user\site\hosted environment.

这篇关于备份数据库-错误消息3201和3013的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！