实用SQL命令收集

use master
--备份
backup database pubs to disk='c:\pub.bak' with noinit
--压缩
exec xp_makecab 'c:\pub.cab',mszip,1,'c:\pub.bak'
--解压
xp_unpackcab 'c:\pub.cab','d:\',1