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 |
|
rudba
Constraint Violating Yak Guru
415 Posts |
 Posted - 2009-07-09 : 10:21:48
|
| I used the following script to DIFFERENTIAL backup.Its re-write. Now i check the size differential backup and full backup.The differential backup size is bigger than full backup size.Anybody have an idea why?SET @FileName = @Path + @Name + '_' + @FileDay + '_Diff.BAK' BACKUP DATABASE @Name TO DISK = @FileName WITH DIFFERENTIAL , NOFORMAT, NOINIT, NAME = @FileName, SKIP, NOREWIND, NOUNLOAD, STATS = 5 |
|
|
karthik_padbanaban
Constraint Violating Yak Guru
263 Posts |
Posted - 2009-07-09 : 10:35:38
|
| To my knowledge.more objects would be created after a full backup was done, which increase the size of the database, but it wont increase full backup size which have been taken already. which will be the cause of bigger size of diff backup. Karthik |
 |
|
|
rudba
Constraint Violating Yak Guru
415 Posts |
Posted - 2009-07-09 : 10:52:54
|
| Well, if run the following script 2-3 and check the size. Why its double?BACKUP DATABASE [msdb] TO DISK = N'E:\DbBak\msdb_diff.bak' WITH DIFFERENTIAL , NOFORMAT, NOINIT, NAME = N'msdb-Differential Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10 |
|
|
|
|
|
|
|
|
differential backup