Full Database backup size.....

When I take the full backup of the database the size of the backup file
varies.
Here is the scenario.
When I took for the first day, the size of the database was 1.5gb
Next day full back up size was 1.6gb(it had today's business data)
Third day full bakup is 1.4gb (it had the third day business data)
None of my application deletes the data from the above database.
Is it not the size of the backup file should increase as the data in the
database grows?
Is there any other factor (like shrinking etc....) is affecting the size of
the backup file.
SQL2K.
Just curious.
Thanks,
Allen
The size of the backup can also fluctuate based on non-data space being
consumed by the database. For example, if the data device is 15gb, 10gb in
use by data and 5gb free and/or the log is 5gb, with 2gb in use and 3gb free,
the overall backup size will be different/larger then if there was no
unused/white-space in the DBs devices.
"AllenHubatka" wrote:

> When I take the full backup of the database the size of the backup file
> varies.
> Here is the scenario.
> When I took for the first day, the size of the database was 1.5gb
> Next day full back up size was 1.6gb(it had today's business data)
> Third day full bakup is 1.4gb (it had the third day business data)
> None of my application deletes the data from the above database.
> Is it not the size of the backup file should increase as the data in the
> database grows?
> Is there any other factor (like shrinking etc....) is affecting the size of
> the backup file.
> SQL2K.
> Just curious.
> Thanks,
> Allen
>
>
|||if the Dboption you have chosen Is it Full or Simple and If set to
simple The Log file Will be Shrunk when it Reaches more than 70% on a
checkpoint and also if you have checked autoShrink option both the
data and log file will be shrink ,its a background operation which
happens when u r server isnt busy enough.
Thanks,
Saradhi
|||The database backup process goes to the Tlog to capture all of the
transactions since the backup began... which can increase the size...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"AllenHubatka" <AllenHubtka_67@.hotmail.com> wrote in message
news:OrGCxLZqFHA.2596@.TK2MSFTNGP09.phx.gbl...
> When I take the full backup of the database the size of the backup file
> varies.
> Here is the scenario.
> When I took for the first day, the size of the database was 1.5gb
> Next day full back up size was 1.6gb(it had today's business data)
> Third day full bakup is 1.4gb (it had the third day business data)
> None of my application deletes the data from the above database.
> Is it not the size of the backup file should increase as the data in the
> database grows?
> Is there any other factor (like shrinking etc....) is affecting the size
> of
> the backup file.
> SQL2K.
> Just curious.
> Thanks,
> Allen
>