(sqlserver) 数据库的最佳/最快压缩格式？
有没有人找到 MS Sqlserver 数据库的良好压缩格式？ 如果是这样，您使用什么并且对其性能感到满意吗？
我的公司经常会压缩来自我们一个客户的数据库快照并下载它，以便我们有一个本地副本用于测试和开发目的。 我们过去尝试过 zip，但是一旦数据库文件超过 4Gb 边界，我们就必须使用 rar（zip 仅限 32 位）。 问题是 rar 需要很多时间来压缩，而且我们也不知道它是否给我们提供了最佳的压缩比。
这不是压缩实用程序的问题，而是压缩格式的问题。 我们使用 WinRar，但正在考虑使用 7zip，它支持多种格式。
Has anyone found a good compression format for MS Sqlserver databases? If so, what do you use and are you pleased with how it performs?
My company frequently will compress a database snapshot from one of our clients and download it so we have a local copy for testing and dev purposes. We tried zip in the past, but once the database files crossed the 4Gb boundary we had to use rar (zip is 32-bit only). The problem is rar takes a lot of time to compress, and we don't know if it gives us the best compression ratio either.
This isn't a question about the compression utility so much as the compression format. We use WinRar, but are considering 7zip, which supports a number of formats.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（4）
我已经尝试过大多数用于 SQL bak 压缩的压缩算法，明显的赢家是旧的且被遗忘的 freearc！
它的速度/压缩比是我见过的最好的。 它甚至向存档添加恢复块，因此如果它被损坏（例如字节丢失），它可以自我恢复。
版本0.67可以从peazip包中获取(sourceforge.net)< br>
下载
peazip_portable-8.7.0.WIN64.zip包并解压以获取freearc压缩工具。命令示例：
Arc.exe create -m3 --recovery "c:\temp\SQL.bak.arc" "c:\temp\SQL.bak"SQL bak 文件示例444MB< /强>：
arc，级别 3：存档大小：48MB，时间 0:38 分钟（即使有恢复块！）
7z，级别 Normel：arvhice 大小：57MB，时间 1:54 分钟
（都是 4 个线程）
这是一件令人悲伤的事情，它从世界上消失了，而且没有人接手这个项目。 但我认为只是为了功能丰富，该项目简单到全面。
如果您需要更多链接和来源，请告诉我...我已尝试尽可能多地收集，有些已经从网络上消失了:-(
I've tried most compression algorithm for SQL bak compression and the clear winner is the old and all forgotten freearc!
It's speed/compression ratio is the best I've seen. It even adds recovery blocks to the archive, so if it gets corrupted (e.g. bytes got lost) it can self-recover.
Version 0.67 can be retrieved from the peazip package (sourceforge.net)
Download the package
peazip_portable-8.7.0.WIN64.zipand extract to grab the freearc compression tool.Command example:
Arc.exe create -m3 --recovery "c:\temp\SQL.bak.arc" "c:\temp\SQL.bak"Example SQL bak file 444MB:
arc, level 3: archive size: 48MB, time 0:38 min (even with recovery blocks!)
7z, level normel: arvhice size: 57MB, time 1:54 min
(both 4 threads)
It's a sad thing it kind of disappeared from the world and no one took over the project. But I think it was just to feature rich, the project was simple to comprehensive.
Let me know if you need more links and source...I've tried to collect as much as possible, some has disappeared from the web since :-(
总有UCL 压缩 和/或LZO 压缩，两者都是 GPL，所以如果是商业项目，请确保您知道如何使用它们。
There's always UCL compression and or LZO compression, both are GPLed so be sure you know how you're using them if it is a commercial project.
在免费类别中，较新版本的 gzip 和 bzip2 应该包含大文件支持（互联网上有人告诉我，由于 Cyril Pilsko，bzip2 1.0.1 及更高版本是大文件兼容的，而gzip 1.2 可以修补可下载的二进制文件，并且 gzip 1.3 beta 包含支持）。 虽然为了方便起见，我在 Windows 电脑上使用 7zip，但出于速度与压缩方面的考虑，我倾向于选择 bzip2。
我还听说过通过执行类似
cat file | 之类的操作来欺骗非大文件版本。 gzip > 文件.gz。 通常，您会在时间和压缩级别之间进行权衡，但 bzip2 的声明之一是它解压缩速度非常快，这在灾难恢复情况下应该是您最重要的指标。 在这方面，我相信 EMC 的磁带备份解决方案（ELM？）默认情况下会跳过数据库分区的压缩。 另外，如果您真的想将其打包到一个小空间中，您可以尝试类似 rzip 的东西，但是我从未见过有人真正使用过它。In the no-cost category, newer versions of gzip and bzip2 are supposed to include large file support (someone on the internet tells me that bzip2 1.0.1 and beyond is large file compatible thanks to Cyril Pilsko, while gzip 1.2 can be patched which the dowloadable binaries are, and the gzip 1.3 beta includes support). While I use 7zip on my windows pc for convenience, I tend to prefer bzip2 for speed vs compression.
I have also heard of tricking the non-large-file versions by doing something like
cat file | gzip > file.gz. Generally you're trading off time with compression level, but one of bzip2's claims is that it uncompresses very quickly, which in a disaster recovery situation should be your most important metric. In that regard, I believe EMC's tape backup solution (ELM?) used to skip compression on DB partitions by default. Also If you're really serious about packing it into a tiny space, you might try something like rzip, but I've never known anyone to actually use it.在 sql 2008 中，您有本机压缩，如果您必须经常执行此操作并且没有 SQL Server 2008，请查看类似 Quest LiteSpeed 自动压缩备份
In sql 2008 you have native compression, if you have to do this a lot and don't have SQL server 2008 then take a look at something like Quest LiteSpeed which compreeses the backup automatically