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...
>
>

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 Server
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...
> 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 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
|||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...
>
>