使用7ZIP定期压缩数据库，并备份到异机

::将以下代码保存为BAT文件，并在计划任务中定时执行

::压缩数据库

"C:\Program Files\7-Zip\7z.exe" a 

E:\backup\SQL_backup_%DATE:~0,4%%DATE:~5,2%%DATE:~8,2%.7z 

E:\backup\SQL_backup_%DATE:~0,4%%DATE:~5,2%%DATE:~8,2%0030.bak

::复制到异机

net use Y: \\ "PASSWORD" /user:"USERNAME"

copy E:\backup\SQL_backup_%DATE:~0,4%%DATE:~5,2%%DATE:~8,2%.7z Y:\

net use Y: /del