如何在Lan上将数据库备份到另一台计算机上 [英] How Do I Take Database Backup Into Another Computer On Lan

问题描述

如何将数据库备份带到另一台LAN计算机上。我试着跟随脚本：BACKUP DATABASE [ppp] TO DISK = N'\Sbt_main_server\bijli\BackUp\pp'WITH NOFORMAT，NOINIT，NAME = N'ppp-Full Database Backup'，SKIP，NOREWIND， NOUNLOAD，STATS = 10 GO



但我有以下错误：消息3201，等级16，状态1，行1

无法打开备份设备'\\ABHIJIT-PC\Users\Public\database_backup'。操作系统错误5（无法检索此错误的文本。原因：15105）。

消息3013，级别16，状态1，行1

BACKUP DATABASE异常终止。



请帮帮我

How can i take database backup into another computer which is LAN. I have try to following script: BACKUP DATABASE [ppp] TO DISK = N'\Sbt_main_server\bijli\BackUp\pp' WITH NOFORMAT, NOINIT, NAME = N'ppp-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10 GO

BUT i have the following error: Msg 3201, Level 16, State 1, Line 1
Cannot open backup device '\\ABHIJIT-PC\Users\Public\database_backup'. Operating system error 5(failed to retrieve text for this error. Reason: 15105).
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.

Please help me

推荐答案

听起来您的MSSQL服务器帐户没有必要的权限来访问您用来写备份文件的网络共享。



有看一下标题为备份到网络共享上的文件的部分在本文档中。



希望有所帮助。

Hi,

It sounds like your MSSQL server account does not have the necessary rights to access the network share you are using to write the backup file to.

Have a look at the section titled "Backing Up to a File on a Network Share" in this document.

Hope it helps.

这篇关于如何在Lan上将数据库备份到另一台计算机上的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！