Differential Vs. Full DB backup

My database is 30Gb in size. Full DB backup takes 30Gb and Differential
backup only 24 hrs later takes... 29.5Gb!
There is no heavy activity on database, 95% of database pages could not be
changed over 24 hr period.
Any advise on Differential backup size? It shouldn't be as big as Full DB
backup.
Thanks,
Leon Shargorodsky
My guess is that you have performed either reindexing or a shrink operation.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Leon Shargorodsky" <LeonShargorodsky@.discussions.microsoft.com> wrote in message
news:D99B2F64-6F5F-4552-B99F-5806477B8783@.microsoft.com...
> My database is 30Gb in size. Full DB backup takes 30Gb and Differential
> backup only 24 hrs later takes... 29.5Gb!
> There is no heavy activity on database, 95% of database pages could not be
> changed over 24 hr period.
> Any advise on Differential backup size? It shouldn't be as big as Full DB
> backup.
> Thanks,
> Leon Shargorodsky
|||A differential backup backs up all modified pages since the last full. If
you have modified the data, by any mechanism, then they would be written to
the differential backup. So, look for CRUD operations against the database
including index defrag, index rebuild, and database shrink operations, which
re-write index and/or data pages and are recorded differences that will
accumulate in the differential backup.
Sincerely,
Anthony Thomas

"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:u0ejm7UCFHA.560@.TK2MSFTNGP15.phx.gbl...
My guess is that you have performed either reindexing or a shrink operation.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Leon Shargorodsky" <LeonShargorodsky@.discussions.microsoft.com> wrote in
message
news:D99B2F64-6F5F-4552-B99F-5806477B8783@.microsoft.com...
> My database is 30Gb in size. Full DB backup takes 30Gb and Differential
> backup only 24 hrs later takes... 29.5Gb!
> There is no heavy activity on database, 95% of database pages could not be
> changed over 24 hr period.
> Any advise on Differential backup size? It shouldn't be as big as Full DB
> backup.
> Thanks,
> Leon Shargorodsky