数据库备份-差异文件大小问题
对于 SQL Server 2005 的备份计划，我想在周日执行完整备份：
BACKUP DATABASE myDatabase TO DISK = 'D:\Database Backups\myDatabase_full.bak' WITH FORMAT
GO
然后我想在本周剩余的时间每晚执行差异备份：
BACKUP DATABASE myDatabase TO DISK = 'D:\Database Backups\myDatabase_Diff.bak' WITH DIFFERENTIAL
GO
我的假设是，如果数据库中几乎没有/没有活动，则差异备份大小不会增加（或不会增加太多）。
但是，当我运行上面的差异备份（很少或没有活动）时，我发现差异备份一次增加了我的内存。为什么会这样增加呢？
谢谢
For my backup plan for SQL Server 2005, I want to do a full on Sunday:
BACKUP DATABASE myDatabase TO DISK = 'D:\Database Backups\myDatabase_full.bak' WITH FORMAT
GO
Then I want to do a differential nightly the rest of the week:
BACKUP DATABASE myDatabase TO DISK = 'D:\Database Backups\myDatabase_Diff.bak' WITH DIFFERENTIAL
GO
My assumption was that if there was little/no activity in the database, then the differential would not increase in size (or wouldn't increase by much).
However, when I run the differential backup above (with little or no activity), I'm seeing the differential backup increase my megs at a time. Why is it increasing like that?
Thanks
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我必须说，首先我会像你一样考虑差异备份大小......所以我必须检查它......从我能读到的内容：
缺点是如果你在完整备份后运行多个差异备份，你每个差异备份中可能包含一些文件，这些文件已包含在早期差异备份中，但最近尚未修改
我仍在尝试查找可以包含哪些类型的文件，但似乎无法找到完整备份中没有的文件答案是，但从我看来，备份增长很多的原因是……我仍然会继续寻找，如果我找到答案，我会回来发表评论
i must say at first i would have thought like you about the differential backup size ... so i had to check it up... from what i could read :
The downside is if you run multiple differential backups after your full backup, you're probably including some files in each differential backup that were already included in earlier differential backups, but haven't been recently modified
i am still trying to find what kind of file could be included that were not in the full backup cant seem to find the answer but from what i could see the reason of the backup growing by a lot would be that ... im still gonna keep looking if ever i find the answer ill come back and comment