计算数据库备份大小 [英] Calculating DB backup size
问题描述
在我们实际进行备份之前，有没有办法知道数据库完整备份文件的大小?我做了一些分析，认为 sp_spaceused 可以给出一个接近的数字，但这还不是全部，除了已用空间之外，似乎还有一个/多个因素决定了大小?
Is there a way to know the size of a database full backup file before we actually do the backup? I did some analyses and figured sp_spaceused could give a close figure but thats not all, there seem(s) to be one/more factors other than the used space that go into determining the size?
以前有人走过这条路吗?有什么想法吗?
Has anyone been down this path before? Any ideas?
推荐答案
sp_spaceused 如果您查看保留空间，应该非常接近.
sp_spaceused should be pretty close if you look at the reserved space.
Paul Randal 最近发表了关于如何知道您的 TLOG 备份可能有多大的博客:
Paul Randal blogged recently about how to know how large your TLOG backup might be:
在一些简短的测试中，这两个值的组合似乎非常接近实际的备份大小.
A combination of the two values, seems to be really close to the actual backup size in some brief testing.
这篇关于计算数据库备份大小的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
