Hello,

Is there a way to delete backup files older than a month.

Every day SQL maintenance plan makes a file like this:
database_backup_200806161420.bak

But now i have manually delete files after a month ... because backups older
than a month aren't useful.

Thank you,
Koen

Hi
What is the version of SQL Server?



"Koen Verwimp" <KoenVerwimp@discussions.microsoft.com> wrote in message
news:F0D17A74-42A5-406C-A179-7C964E336D6F@microsoft.com...
> Hello,
>
> Is there a way to delete backup files older than a month.
>
> Every day SQL maintenance plan makes a file like this:
> database_backup_200806161420.bak
>
> But now i have manually delete files after a month ... because backups
> older
> than a month aren't useful.
>
> Thank you,
> Koen

Koen,

In the Maintenance Plan designer you can include a Maintenance Cleanup task.
Drag it into the designer and choose your settings on which file to delete
and when. (In SQL Server 2000, this was defined as all of one piece with
the backup plan, but now it is a separate task within the plan.)

RLF

"Koen Verwimp" <KoenVerwimp@discussions.microsoft.com> wrote in message
news:F0D17A74-42A5-406C-A179-7C964E336D6F@microsoft.com...
> Hello,
>
> Is there a way to delete backup files older than a month.
>
> Every day SQL maintenance plan makes a file like this:
> database_backup_200806161420.bak
>
> But now i have manually delete files after a month ... because backups
> older
> than a month aren't useful.
>
> Thank you,
> Koen

I have SQL 2005 Developer.

I created a Maintenance Cleanup task ...

Can i specify d:\backup ... are all subfolders under this cleanup task? Or
do I have to create a cleanup task for every folder (every database is in a
seperate folder).

Thanks for ing!

"Russell Fields" wrote:

> Koen,
>
> In the Maintenance Plan designer you can include a Maintenance Cleanup task.
> Drag it into the designer and choose your settings on which file to delete
> and when. (In SQL Server 2000, this was defined as all of one piece with
> the backup plan, but now it is a separate task within the plan.)
>
> RLF
>
> "Koen Verwimp" <KoenVerwimp@discussions.microsoft.com> wrote in message
> news:F0D17A74-42A5-406C-A179-7C964E336D6F@microsoft.com...
> > Hello,
> >
> > Is there a way to delete backup files older than a month.
> >
> > Every day SQL maintenance plan makes a file like this:
> > database_backup_200806161420.bak
> >
> > But now i have manually delete files after a month ... because backups
> > older
> > than a month aren't useful.
> >
> > Thank you,
> > Koen
>
>
>

Koen,

Does your Maintenance Cleanup task properties have a check box entitled
"Include first-level subfolders"? If so, check that to get the subfolders
one level down, which is where individual database backups are stored.

If you do not see this check box, I believe that you need to have the SQL
Server 2005 SP2 installed for the tools. To check your tools version, from
Management Studio use / About. It should say 9.00.3042.00 if you are
using the SP2 tools.

(And, of course, you want to make sure that SQL Server engine is upgrade to
SP2 plus, at minimum, up to build 3159. You may, of course, have applied
other Cumulative Updates to get past that point by now.)
http://support.microsoft.com/kb/937137/

RLF


"Koen Verwimp" <KoenVerwimp@discussions.microsoft.com> wrote in message
news:CCA93A74-7EA8-4529-ADFF-B68036C13D8E@microsoft.com...
>I have SQL 2005 Developer.
>
> I created a Maintenance Cleanup task ...
>
> Can i specify d:\backup ... are all subfolders under this cleanup task? Or
> do I have to create a cleanup task for every folder (every database is in
> a
> seperate folder).
>
> Thanks for ing!
>
> "Russell Fields" wrote:
>
>> Koen,
>>
>> In the Maintenance Plan designer you can include a Maintenance Cleanup
>> task.
>> Drag it into the designer and choose your settings on which file to
>> delete
>> and when. (In SQL Server 2000, this was defined as all of one piece with
>> the backup plan, but now it is a separate task within the plan.)
>>
>> RLF
>>
>> "Koen Verwimp" <KoenVerwimp@discussions.microsoft.com> wrote in message
>> news:F0D17A74-42A5-406C-A179-7C964E336D6F@microsoft.com...
>> > Hello,
>> >
>> > Is there a way to delete backup files older than a month.
>> >
>> > Every day SQL maintenance plan makes a file like this:
>> > database_backup_200806161420.bak
>> >
>> > But now i have manually delete files after a month ... because backups
>> > older
>> > than a month aren't useful.
>> >
>> > Thank you,
>> > Koen
>>
>>
>>

I have to install SP2!

Thank you very much!

Grtzz,
Koen

"Russell Fields" wrote:

> Koen,
>
> Does your Maintenance Cleanup task properties have a check box entitled
> "Include first-level subfolders"? If so, check that to get the subfolders
> one level down, which is where individual database backups are stored.
>
> If you do not see this check box, I believe that you need to have the SQL
> Server 2005 SP2 installed for the tools. To check your tools version, from
> Management Studio use / About. It should say 9.00.3042.00 if you are
> using the SP2 tools.
>
> (And, of course, you want to make sure that SQL Server engine is upgrade to
> SP2 plus, at minimum, up to build 3159. You may, of course, have applied
> other Cumulative Updates to get past that point by now.)
> http://support.microsoft.com/kb/937137/
>
> RLF
>
>
> "Koen Verwimp" <KoenVerwimp@discussions.microsoft.com> wrote in message
> news:CCA93A74-7EA8-4529-ADFF-B68036C13D8E@microsoft.com...
> >I have SQL 2005 Developer.
> >
> > I created a Maintenance Cleanup task ...
> >
> > Can i specify d:\backup ... are all subfolders under this cleanup task? Or
> > do I have to create a cleanup task for every folder (every database is in
> > a
> > seperate folder).
> >
> > Thanks for ing!
> >
> > "Russell Fields" wrote:
> >
> >> Koen,
> >>
> >> In the Maintenance Plan designer you can include a Maintenance Cleanup
> >> task.
> >> Drag it into the designer and choose your settings on which file to
> >> delete
> >> and when. (In SQL Server 2000, this was defined as all of one piece with
> >> the backup plan, but now it is a separate task within the plan.)
> >>
> >> RLF
> >>
> >> "Koen Verwimp" <KoenVerwimp@discussions.microsoft.com> wrote in message
> >> news:F0D17A74-42A5-406C-A179-7C964E336D6F@microsoft.com...
> >> > Hello,
> >> >
> >> > Is there a way to delete backup files older than a month.
> >> >
> >> > Every day SQL maintenance plan makes a file like this:
> >> > database_backup_200806161420.bak
> >> >
> >> > But now i have manually delete files after a month ... because backups
> >> > older
> >> > than a month aren't useful.
> >> >
> >> > Thank you,
> >> > Koen
> >>
> >>
> >>
>
>
>