Backup

I want to backup a database every day, but i want that at some point (ex.
when there are 5 bakupsets) it replaces the previous backups, one at a time.
Can you help me'You may want to take a look at the BACKUP DATABASE command help file.
With the RETAINDAYS option, you will be able to do just that.
A stored procedure running daily as a job will then be all you need.|||A lot of us prefer to use a different file for each backup. You don't want
to take a chance of one mistake or problem corrupting the whole set of
backups you have. Tara Duggan has a script written for backups. You can
set the number of retain days, so it sounds exactly like what you're looking
for. Here is the link:
http://weblogs.sqlteam.com/tarad/ar...08/04/1876.aspx
"Marfig" <marfig@.gmail.com> wrote in message
news:1110558250.287530.240470@.f14g2000cwb.googlegroups.com...
> You may want to take a look at the BACKUP DATABASE command help file.
> With the RETAINDAYS option, you will be able to do just that.
> A stored procedure running daily as a job will then be all you need.
>