为什么SQL Server备份比数据库文件大得多? [英] Why is SQL Server backup so much larger than the DB files?

问题描述

我有一个大约13Gb的SQL Server数据库，带有一个1.6Gb的日志文件.但是，当我备份它时，它将创建一个50Gb .bak文件！为什么会这样?

I have a SQL Server DB that is about 13Gb with a 1.6Gb log file. When I back it up, however, it creates a 50Gb .bak file! Why is that?

我在这里阅读了一些有关事务日志的评论，但是我的数据库在笔记本电脑上运行，并且在备份期间没有数据库活动.(仅需5分钟).

I have read some commentary here about transaction logs, but my DB runs on my laptop and there is no DB activity during the time of the backup. (It only takes 5 minutes).

我的备份类型为完全"，我的恢复类型为完全"，并且我正在执行仅复制"备份.有任何想法吗?非常感谢！

My backup type is Full, my recovery type is Full, and I am doing Copy-Only backups. Any ideas? Much appreciated!

我正在使用SQL 2008 R2，开发版.

I am using SQL 2008 R2, Developer Edition.

推荐答案

这可能是因为备份例程将新备份附加到同一文件吗?

It might be because the backup routine is appending the new backup to the same file?

在Sql Management Studio中的备份"对话框中有一个选项可以追加或覆盖所有现有备份集.如果您具有附加"，则将备份添加到相同的.bak文件中，并且每个备份的.bak文件都会更大.

There is an option in the Backup dialog in Sql Management Studio to Append or Overwrite all existing backup sets. If you have Append if will add the backup to the same .bak file and the .bak file will be larger for every backup.

在Transact Sql中，INIT和NOINIT选项确定bak文件是否被覆盖或附加.

In Transact Sql it is the INIT and NOINIT option which determine if the bak file is overwritten or appended.

这篇关于为什么SQL Server备份比数据库文件大得多?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！