sql异地备份语法.txt

SQL语言常用的一些命令各代码

 master.dbo.xp_cmdshell 'net use \\192.168.1.30\data-bk meihua602  /user:192.168.1.30\meihua'

BACKUP DATABASE [TVC] TO  DISK = N'\\192.168.1.30\data-bk\TVC.bak' WITH  NOINIT