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 dis
k
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 manual
ly
> delete the .bak and .trn files that are three days old to allow for more d
isk
> 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 automat
ed
> way to do this. Is there a way, tool, script somewhere that I could use t
o
> manage this automatically? Thank you.
http://realsqlguy.com/serendipity/a...th-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|||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 p
ackage 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...
>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 manual
ly
> delete the .bak and .trn files that are three days old to allow for more d
isk
> 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 automat
ed
> way to do this. Is there a way, tool, script somewhere that I could use t
o
> manage this automatically? Thank you.|||Thanks
"Tracy McKibben" wrote:

> morphius wrote:
> http://realsqlguy.com/serendipity/a...th-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...
>