curious phenomenon when differential backup

Hello,
when i backup my database on one day in week with a full backup and the
other day with a differential backup (for example: full on sunday, all
other days differential) i think the differential archive from friday
should be bigger than the differential archive from tuesday(when noting
is erased and only datas where changed). but it isnt.
what can be happend?
for example the differential backup from tuesday is nearly 2 GB and the
differential archive is nearly 400 MB. Fullbackup only made on Sunday
and there is no other backup running on the system.
thx for every ideaWhat you describe sounds impossible, from a theoretical standpoint. I would start checking the
backup* history tables in the msdb to be absolutely 100% certain that a database backup haven't been
performed in between.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Werner Stiglbrunner" <werner_stiglbrunner@.at.ibm.com> wrote in message
news:ua4tXt82GHA.1292@.TK2MSFTNGP03.phx.gbl...
> Hello,
> when i backup my database on one day in week with a full backup and the other day with a
> differential backup (for example: full on sunday, all other days differential) i think the
> differential archive from friday should be bigger than the differential archive from tuesday(when
> noting is erased and only datas where changed). but it isnt.
> what can be happend?
> for example the differential backup from tuesday is nearly 2 GB and the differential archive is
> nearly 400 MB. Fullbackup only made on Sunday and there is no other backup running on the system.
> thx for every idea|||Tibor Karaszi schrieb:
> What you describe sounds impossible, from a theoretical standpoint. I would start checking the
> backup* history tables in the msdb to be absolutely 100% certain that a database backup haven't been
> performed in between.
>
your right i also think that this is impossible.
i will research this situation on the next days and hope that i find a
"simple" declaration.