Re: Maintenance Plan Changes in SQL Server 2005 SP2
- From: "Alex Petrovsky" <god_enigma@xxxxxxx>
- Date: Mon, 26 Mar 2007 18:03:31 +0400
Hello,
I used method:
public void AddAgentJob(ServerConnection LocalConnObj, string proxyName)
(class
Microsoft.SqlServer.Management.DatabaseMaintenance.MaintenancePlanSubPlan)
but after installing SP2 for MS SQL Server, I can't find it.
"Ed Lehman [MSFT]" <edle@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:uKlNt%23%23VHHA.4668@xxxxxxxxxxxxxxxxxxxxxxx
Users of SQL Server 2005 maintenance plans should be aware of a change in
SP2 that affects existing cleanup tasks until updated using SQL Server SP2
tools.
Who is affected?
You are affected if you use SQL Server 2005 maintenance plans, those plans
include a History Cleanup Task or a Maintenance Cleanup Task, and you
install SQL Server 2005 SP2. Users of SQL Server 2000 legacy maintenance
plans are not affected.
What is the issue?
Some maintenance plans might include the Maintenance Cleanup Task and the
History Cleanup Task, which allow users to delete information older than a
specified interval. When SQL Server 2005 was released, this interval was
measured in days, weeks, months, or years. In response to customer
feedback, SQL Server 2005 SP2 includes significant enhancements to
maintenance plans, including an enhancement that allows users to specify
the cleanup interval in hours. After upgrading to SP2, and until you
update cleanup tasks using SQL Server SP2 tools as described below,
existing cleanup task intervals are misinterpreted. This leads to earlier
data cleanup than was intended.
What if I have already installed SP2 on my server?
You can restore your maintenance plans to their former behavior by opening
them up in the Maintenance Plan Designer, opening any cleanup tasks,
adjusting the age units to the proper value, and saving the maintenance
plan. Use SQL Server 2005 SP2 tools to make these changes.
What if I haven't yet installed SP2 on my server?
We are currently investigating our approach to this problem and will
provide guidance shortly. If you depend on the Maintenance Cleanup Task or
the History Cleanup Task and are not able to verify and possibly update
cleanup tasks using matching server and tool versions, you may want to
wait for that guidance before installing SP2.
.
- Prev by Date: Modify default Enterprise Manager font.
- Next by Date: Re: How to Measure TPM Tool?
- Previous by thread: Modify default Enterprise Manager font.
- Next by thread: conversion
- Index(es):
Relevant Pages
|
