Maintenance Plan

When setting up a maintenance plan in SQL 2000, there is a "...remove files
older than...", option. I don't see it in SQL 2005 when creating a
maintenance plan.
Does this option exist inf SQL 2005? If it does, where can I find it? Thanks
to everyone for being there to help.
SQL 2005 ServerHi
It was completely changed. What does the MP do?
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:91D15026-DBAA-4F8F-B126-B2BE60AF3B8B@.microsoft.com...
> When setting up a maintenance plan in SQL 2000, there is a "...remove
> files
> older than...", option. I don't see it in SQL 2005 when creating a
> maintenance plan.
> Does this option exist inf SQL 2005? If it does, where can I find it?
> Thanks
> to everyone for being there to help.
> SQL 2005 Server|||You don't find this in the wizard. Open the plan in the designer (FROM SSMS)
, and add that task.
Note that sp1 is required to traverse subfolders.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:91D15026-DBAA-4F8F-B126-B2BE60AF3B8B@.microsoft.com...
> When setting up a maintenance plan in SQL 2000, there is a "...remove file
s
> older than...", option. I don't see it in SQL 2005 when creating a
> maintenance plan.
> Does this option exist inf SQL 2005? If it does, where can I find it? Than
ks
> to everyone for being there to help.
> SQL 2005 Server|||Three separate plans; Full, Differential, aand transaction log backups.
"Uri Dimant" wrote:

> Hi
> It was completely changed. What does the MP do?
>
> "coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
> news:91D15026-DBAA-4F8F-B126-B2BE60AF3B8B@.microsoft.com...
>
>|||Found it. It's in the Maintenance Plan Tasks as Maintenance Cleanup Task.
"Uri Dimant" wrote:

> Hi
> It was completely changed. What does the MP do?
>
> "coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
> news:91D15026-DBAA-4F8F-B126-B2BE60AF3B8B@.microsoft.com...
>
>