1,先备份,然后用Winrar压缩(备份时间正常,压缩时间很长。最大的问题是解压缩时间太长,在恢复的时候需要等候,影响系统在线时间)
2 .在NTFS格式下建一个文件夹,起用压缩,然后备份到这个文件夹(备份时间变长,还原时间也长)
3。起用压缩胡备份(压缩时间短,还原时间也短[这点非常重要],但是缺点是CPU使用率高)
普通备份
Backup Database AdventureWorks
To Disk='C:/Backup/Adv_1.bak'
-- 10.285 seconds (12.795 MB/sec).
备份到NTFS压缩文件夹
Backup Database AdventureWorks
To Disk='C:/Backup/NTFS_C/Adv_2.bak'
-- 17.274 seconds (7.616 MB/sec).
带压缩的备份
Backup Database AdventureWorks
To Disk='C:/Backup/Adv_3.bak'
With Compression
-- 5.216 seconds (25.224 MB/sec).
以下是还原时间
Restore Database AdventureWorks
From Disk='C:/Backup/Adv_1.bak'
With Replace
-- 8.059 seconds (16.330 MB/sec).
Restore Database AdventureWorks
From Disk='C:/Backup/NTFS_C/Adv_2.bak'
With Replace
-- 5.419 seconds (24.279 MB/sec).
Restore Database AdventureWorks
From Disk='C:/Backup/Adv_3.bak'
With Replace
-- 6.171 seconds (21.320 MB/sec).
所以,对于大型数据库,可以将备份时压缩设置为缺省值(Server Properties-->Database settings-->Compress BackUp )