SQL 2005 express

[autumn801]

We backup through SQL management console a database that is about 1.2G big.

We do a full backup, which appends each day.
By the end of the week this backup file grows to about 6.7G.
Does anyone know why this happens. I mean the dB is only 1.2G big.
But after the weekend backup, it grows to 6.7G.

thanks

[SpywareDr]

1.2GB times 5 working days a week equals 6GB

If you do another weekend backup then 6GB + 1.2GB = 7.2GB

[autumn801]

I still don't understand, so what your telling me it just keeps adding the database on top of each backup.
Meaning, after the 1st backup, a second backup happens the next day, and then it just keeps adding 1.6G each day.

Can you put that in english. thanks

[Steve R Jones]

Some settings to look at in Enterprise Manager->

Database – differential
Perform a differential database backup. A differential backup records only the changes made to the data in the database after the last full database backup.

Append to media
Append the backup to an existing media. The previous contents of the media remain intact, and the new backup is written after the end of the last backup on the media.

Overwrite existing media
Specify to overwrite any existing media. By overwriting backups on media, the existing contents of the backup media are overwritten with the new backup and therefore are no longer available.

[SpywareDr]

...
We do a full backup, which appends each day.

"Append" is the key word ... meaning "Add-to", (i.e., add-to the end of the existing file).