- ::备份至远程主机
- "D:\\SQL Server\\100\\Tools\\Binn\\SQLCMD.EXE" -S <server host> -U sa -P 123456 -d master -Q"BACKUP DATABASE <dbname> to disk='\\\\<host>\\sql\\sql.bak'"
- ::从远程主机恢复
- "D:\\SQL Server\\100\\Tools\\Binn\\SQLCMD.EXE" -S <server host> -U sa -P 123456 -d master -Q"RESTORE DATABASE <dbname> from disk='\\\\<host>\\sql\\sql.bak'"
- --该片段来自于http://www.codesnippet.cn/detail/040220132083.html
来源: http://www.codesnippet.cn/detail/040220132083.html