网络拷贝数据

USE master
--映射盘符Z
exec master..xp_cmdshell 'net use z: \\192.168.0.117\c$ "密码" /user:192.168.0.117\administrator'
--映射后拷贝
EXEC xp_cmdshell 'copy e:\0724.bak z:\',NO_OUTPUT
--映射后删除
exec master..xp_cmdshell 'net use z: /delete'

原文地址:https://www.cnblogs.com/azhai/p/459523.html