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 data
base 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 ot
her day with a
> differential backup (for example: full on sunday, all other days different
ial) i think the
> differential archive from friday should be bigger than the differential ar
chive 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 di
fferential 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 woul
d start checking the
> backup* history tables in the msdb to be absolutely 100% certain that a da
tabase 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.