SQL Server 备份大小
有谁有 Sql 2008 中备份压缩的实际经验吗？我想知道它与 Sql 2005 + winrar 相比的性能如何。 目前，当我备份时，我得到一个 14G 的文件。 使用 rar 将其缩小到 <400M，这是一个巨大的节省。 大多数数据都是相似的，都是来自股票市场的数据，所以我想这很容易压缩。
Does anyone have real world experience of backup compression in Sql 2008, I'd like to know how it performs compared to Sql 2005 + winrar. Currently when I back up a I get a 14G file. Using rar shrinks it to <400M, a massive saving. Most of the data is similar, being figures from the stock market so I guess that makes it easy to compress.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
我看到的数字建议压缩比小 3 - 4.5 倍，这不如您引用的 rar 数字。 请参阅 调整 SQL Server 2008 中备份压缩的性能。
顺便说一句，创建压缩备份速度更快。
The figures I have seen suggest compression ratios in the range 3 - 4.5 times smaller, which is not as good as the figures you quoted for rar. See Tuning the Performance of Backup Compression in SQL Server 2008.
On a side note, creating compressed backups is faster.
恢复时间对于备份来说非常重要。 如果压缩备份，您将花费更多时间来恢复它。
Time to restore is an important thing for backups. If you compress your backups, you will spent more time to restore it.
我有一个从 200GB 到 50GB 的容量，绝对不像 WinRar 那样紧凑，但方便得多。 正如其他人所指出的，备份时间更快，但恢复时间（有点）长，但仍然比 SQL2000 快得多。
I've got one that goes from 200GB down to 50GB, definitely not as compact as WinRar is getting you, but a lot more convenient. As others have noted, backup time is quicker, but restore time is (a bit) longer but still way quicker than SQL2000.