Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
n0rr15
Starting Member
3 Posts |
 Posted - 2012-05-17 : 14:01:54
|
| So I came in today and determined that my backups are HUGE. At this point we take a Full backup once a week and DIFFs daily. I use litespeed to do this. As of now my full is approx 96gb and my diff is also about 95gb. Lots of changes in the DB is creating this huge diff backup so my question is this.If I do a full backup today, rather than waiting for Saturdays scheduled backup, will a smaller diff be created on the next scheduled DIFF backup execution?Rick Norris |
|
|
chris_cs
Posting Yak Master
223 Posts |
Posted - 2012-05-18 : 05:36:01
|
| The diff backup will contain all the changes since your last full backup so the longer after your full backup the diff occurs, the larger the backup file will be.----------------------------Junior DBA learning the ropes |
 |
|
|
prett
Posting Yak Master
212 Posts |
Posted - 2012-05-24 : 02:26:36
|
| The number of log records in the ldf file affects the size of diff backups. Are you doing index rebuilds or reorganize? This is also the one another reason of huge diff backup. |
|
|
|
|
|
|
Huge Full and DIFF