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 |
|
duhaas
Constraint Violating Yak Guru
310 Posts |
 Posted - 2008-06-11 : 13:59:34
|
| In playing with differential backups, i have taken a full last night, 17GB, took my first diff today 16.5GB, took another diff right after, it was still 16.5GB, took another diff right after 16.5 GB. This database has 0 activity during the day, the import takes place @ night, and select's are done to it during the day. Any help would be greatly appreciated |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-06-11 : 14:06:25
|
| A differential backup includes all of the changes since the last full backup. So yes it should be 16.5GB if you are doing them right after each other. Use transaction log backups if you just want incremental backups.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
duhaas
Constraint Violating Yak Guru
310 Posts |
Posted - 2008-06-11 : 15:04:13
|
| Ok, I guess I was under the assumption that it would be a "differential" meaning the backup itself would just include the changes, meaning the backup file would be tiny. |
|
|
|
duhaas
Constraint Violating Yak Guru
310 Posts |
Posted - 2008-06-11 : 15:11:18
|
| Nevermind, I get it now, sorry, thanks. |
|
|
|
|
|
|
|
|
Diff Backup