exec master..xp_cmdshell 'net use x: \\target ip\lxl_files "pwd" /user:src ip\user' //添加网络磁盘 exec master..xp_cmdshell 'dir x:' //查看 DBCC TRACEON (1807,-1) //使之可以建库 DBCC TRACEOFF (1807,-1) //可以不用 exec master..xp_cmdshell 'net use x: /delete' //删除网络磁盘链接 附加磁盘驱动器数据库命令 CREATE DATABASE SKSpiderFile ON ( FILENAME = N'X:\sqlServer data\SKSpiderFile.mdf' ), ( FILENAME = N'X:\sqlServer data\SKSpiderFile_log.ldf' ) FOR ATTACH |