Backups Question?

I am using a Full recovery model on SQL 2005 with a daily full and 15 min
transactional. The disk constantly keeps getting full and I have to manually
delete the .bak and .trn files that are three days old to allow for more disk
space. My first option was to only do a Full backup once a week and keep
transaction backups at 15 min. Regardless, I still have to have an automated
way to do this. Is there a way, tool, script somewhere that I could use to
manage this automatically? Thank you.
morphius wrote:
> I am using a Full recovery model on SQL 2005 with a daily full and 15 min
> transactional. The disk constantly keeps getting full and I have to manually
> delete the .bak and .trn files that are three days old to allow for more disk
> space. My first option was to only do a Full backup once a week and keep
> transaction backups at 15 min. Regardless, I still have to have an automated
> way to do this. Is there a way, tool, script somewhere that I could use to
> manage this automatically? Thank you.
http://realsqlguy.com/serendipity/archives/9-Out-With-The-Old.html
Note that this uses xp_cmdshell, so you'll need to enable that since
you're on SQL 2005.
Tracy McKibben
MCDBA
http://www.realsqlguy.com
|||Thanks
"Tracy McKibben" wrote:

> morphius wrote:
> http://realsqlguy.com/serendipity/archives/9-Out-With-The-Old.html
> Note that this uses xp_cmdshell, so you'll need to enable that since
> you're on SQL 2005.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>
|||Thanks
"Tibor Karaszi" wrote:

> Maintenance Plans can create new and delete old backup files. The feature of removing old backup
> files is not available in the wizard (until sp2), so make sure to edit the package to add such task.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "morphius" <morphius@.discussions.microsoft.com> wrote in message
> news:1A9D1A49-5BBA-4022-84FF-3158790E0B5C@.microsoft.com...
>