SQL数据库备份到网络位置方法

1.过程

2.语句

exec sp_configure 'show advanced options',1;reconfigure;
exec sp_configure 'xp_cmdshell',1;reconfigure;

EXEC xp_cmdshell 'net use u: /delete /y';
EXEC xp_cmdshell 'net use u: \\192.168.51.5\backup\OA-BAK "ix9Ftk+5@" /user:OA-BAK';
EXEC xp_cmdshell 'dir u:';
 结束语句
EXEC xp_cmdshell 'robocopy D:\T9\ U:\DATA\T9\ /mir /w:1 /r:1 /log:U:\sync.log >nul';
EXEC xp_cmdshell 'robocopy D:\Seeyon\ U:\DATA\Seeyon\ /mir /w:1 /r:1 /log:U:\sync.log >nul';

EXEC xp_cmdshell 'net use u: /delete /y';

exec sp_configure 'show advanced options',1;reconfigure;
exec sp_configure 'xp_cmdshell',0;reconfigure;
如果出现1312错误，可以用下面语句替代
EXEC xp_cmdshell 'net use u: \\192.168.51.5\backup\OA-BAK "ix9Ftk+5@" /user:192.168.51.5\OA-BAK';