如何在Network PC中备份数据.
问题描述:
我想在Network PC中备份数据.
对于本地PC,它正在运行:
I want to backup data in Network PC.
For Local PC it is working :
BACKUP DATABASE HospitalA TO DISK = 'D:\dbP'
像是什么路径:"\\ ABC \ D \ dbP"或"\\ 192.168.1.10 \ D \ dbP"
what is path like : ''\\ABC\D\dbP'' or ''\\192.168.1.10\D\dbP''
答
BACKUP DATABASE Foo TO DISK = '\\myserver\myshare\backFileName.bak' WITH INIT
确保用于sql服务的帐户具有足够的权限,可以在其他网络计算机上写入.
Make sure the account used for the sql services has enough rights to write on other network machine.
如果您尝试使用D-Drive的管理员共享,则需要使用"'\\ ABC \ D
If you are trying to use the admin share of the D-Drive you will need to use ''\\ABC\D
\ dbP"或"\\ 192.168.1.10 \ D
\dbP" or ''\\192.168.1.10\D