SQL Server 2008 外部磁盘备份
我有一个映射在 Y:\ 的外部网络备份磁盘，当我尝试在磁盘 Y:\ 上创建备份时，我
BACKUP DATABASE [DATABASE_NAME] TO DISK = 'Y:\backup\backup.bak' WITH NOFORMAT, INIT, NAME = @BackupName, SKIP, NOREWIND, NOUNLOAD, STATS = 10
在运行它时出现以下错误：
Msg 3201，Level 16，State 1，Procedure sp_backup，Line 10 无法打开备份设备“Y:\backup\backup.bak”。操作系统错误 3（未找到路径。）。
I have an external network back up disc mapped at Y:\ , when I try to create back up on disc Y:\ I have
BACKUP DATABASE [DATABASE_NAME] TO DISK = 'Y:\backup\backup.bak' WITH NOFORMAT, INIT, NAME = @BackupName, SKIP, NOREWIND, NOUNLOAD, STATS = 10
when I run it following error occurs
Msg 3201, Level 16, State 1, Procedure sp_backup, Line 10
Cannot open backup device 'Y:\backup\backup.bak'. Operating system error 3(Path not found.).
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
使用 UNC 路径（例如
\\server\share\backup\backup.bak）。虽然您可能映射了Y驱动器，但运行 SQL Server 的用户帐户却没有映射。正是该“用户”将执行数据访问。Use a UNC path (e.g.
\\server\share\backup\backup.bak). Whilst you may have theYdrive mapped, the user account that SQL Server is running under doesn't. And it's that "user" that is going to perform the data access.驱动器 Y 上可能没有文件夹“backup”：
或者您的帐户没有对此文件夹的适当权限。
It is possible that there is no folder 'backup' on drive Y:
Or your account haven't appropriate permissions to this folder.