如何在映射的网络驱动器中备份sql server [英] how to take the backup of the sql server in the mapped network drive

问题描述

我尝试了这个命令并且它给了我错误

i tried this command and it is giving me error

sp_configure 'xp_cmdshell',1;
Go
RECONFIGURE WITH OVERRIDE;
Go
EXEC XP_CMDSHELL 'net use S: \\192.168.3.111\sqlbackup password /USER:Administrator@192.168.3.111'

错误：-1312和一些时间1219.同一用户使用多个用户名与服务器或共享资源的多个连接，不允许。断开之前与服务器或共享资源的所有连接，然后再试一次。



如何解决这个问题？这么多篇文章都在讨论主机系统的用户名.username或者你的系统

Error:-1312 and some time 1219 .Multiple connections to a server or shared resource by the same user, using more than one user name, are not allowed. Disconnect all previous connections to the server or shared resource and try again.

how to resolve this isssues?so many article are talking about user name .username of the host system or your system

推荐答案

sp_configure 'xp_cmdshell',1; 
Go 
RECONFIGURE WITH OVERRIDE; 
Go
use master
--connect map drive with sql server
 EXEC XP_CMDSHELL 'net use Q: \\servername\sharedflodername password /USER:server name\username'
 --Verify drive mapping .It will display all file map drive
 EXEC XP_CMDSHELL 'Dir Q:'
 --use to delet the mapdrive in sql server
 --EXEC XP_CMDSHELL 'net use Q: /delete'

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