Over write back ups

[sakusan]

Hello,

I am running SQL 2005 and am new to this version. I have produced a maintenance plan to back up my db's on a daily basis and have made the expire after 7 days. It does a full back up for every day and creates a new file.
Is there a way to automatically delete the files after 7 days?. At present I delete manually.
Should this happen anyway?
Many thanks

 

[mrdenny]

You will need to add a step to the maintenance plan. There is a seperate step which covers the removing of files from the hard drive.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog