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

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

MS DOS

::压缩数据库 "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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

::压缩数据库   "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

 

© 2017, ITJOY.NET. 版权所有. 如未注明，均为原创，转载请注明出处。