Schedule Backup Of Specific Database While Only Saving The Last 7 Days In Repository

Hello to all members.
I am using SQL Server 2005 std edition 32 bit
The database is configured in compatibility mode to sql server 2000
The backup mode for the database is configured as simple

With SQL Server Agent I am running schedule task of the backup script

The question is:

I would like to save only the last 7 days in repository.
This means that when the 8th days has become then the 1st day backup is deleted.
in the 9th day the 2nd day backup file is deleted.
and so on

I am using the the T-SQL BACKUP DATABASE command with the following arguments:
RETAINDAYS = 7
NOFORMAT
NOINIT
SKIP

I am in situation that the command above only append to the backup file and without deleting the expired backup days.

What I need to change in the parameters that the script will delete the expired backup days.


It is too much work when working with Database Maintenance Wizard.
lets take a scenario that I have 10 database.
I would like that each database will backup into seperate file.
I need to create 10 * 7 Maintenance plans.

I have created a directory with the name SDBbackup.
Now under the directory SDBbackup I have created 7 directories (1,2,3,4,5,6,7).
Each directory is for Sunday=1 , Monday=2 , and etc.

It's very much work if I need to accomplish it with Database Maintenance Wizard.

This is why I am asking a specific question regarding T-SQL.

Thanking in advance everyone who assist.