利用JOB和DOS执行压缩

1)将WinRAR的安装路径加到系统变量Path中

例如               ;C:\Program Files\WinRAR\

2）建立JOB       rar e \\192.168.12.12\ftp$\csv\erp2crv\*.rar http://www.cnblogs.com/Gsun/admin/file://\\192.168.12.12\ftp$\csv\erp2crv

 

 

 

Dump Transaction huntkeywage with no_log

backup log huntkeywage with no_log

dbcc shrinkdatabase('huntkeywage')