I have a database which I backup every night. The backup type is full, append.
The .BAK file is becoming very big, cause the old backups never are removed.

How can I remove old backups from the .BAK file, and can I make the program do this automaticcally (fe. backups older than 1 month...)

Marc

I'd recommend starting a new backup file, with an expiration date set on the backups (you can do this so it handles it automatically), and then archiving the existing backup.  I think that will do it for you.

---

I couldn't think of anything clever for a signature, so I use this instead.

As you are taking a full backup everyday

You can have Sep backup files for everyday and with Date and time stamp on it. Remove the files older than a month.

You can use winzip to shrink the size of the backup file. After the database Backup is completed. It can reduced the size by 50%.

Regards

Learner