如何将Sql备份带到网络驱动器 [英] How Do I Take A Sql Backup To Network Drive

问题描述

如何从本地服务器备份到网络驱动器。

我已将本地PC加入域名，但我无法访问该驱动器。



我试过的是，

How do i take a from local server backup to network drive.
I have joined my local pc to a domain,but i'm unable to access the drive yet.

what i have tried is,

use master
GO
EXEC sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO

EXEC sp_configure 'xp_cmdshell',1
GO
RECONFIGURE
GO


EXEC XP_CMDSHELL 'net use Z: \\192.168.10.2\AUTOBACKUP\'

但它正在抛出

but it is throwing

System error 53 has occurred.
NULL
The network path was not found.
NULL
NULL

如何解决此问题？

How do i fix this?

推荐答案

问题似乎是特定于权限，如果SQL Server在本地系统帐户下运行显然没有访问\\192.168.10.2。 检查此分辨率 [ ^ ]



然后你可以看看这个如何将SQL Server数据库备份到映射驱动器 [ ^ ]

The problem seems to be permission specific, If SQL Server runs under local system account which obviously dont have access to \\192.168.10.2. Check this for resolution[^]

Then you can look at this How to backup SQL Server databases to a mapped drive[^]

这篇关于如何将Sql备份带到网络驱动器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！