Database Maintenance Plans

I've set up a Database Maintenance Plan that Checks Database Integrity,
Reorganizes Index, Rebuilds Index, Update Statistics and Cleans Up History.
If I set the plan to perform these tasks on either All Databases or All User
Databases, will new databases be detected? Or would I need to recreate the
plan any time a new database is added?You'll need to modify your maintanence plan to include the new ones. They'll
not be added to your old plan automatically.
However, performing all these jobs (I don't know your schedule however
something makes me think it's everyday) may not be appropriate for every
environment.
It's also not a good idea to include all of these jobs only in one plan as
one of these jobs would fail, the others after that failed one would not
work.
--
Ekrem Ã?nsoy
"cc.shine" <cc.shine@.discussions.microsoft.com> wrote in message
news:0011FCDF-395D-4F01-912C-90C189011EBD@.microsoft.com...
> I've set up a Database Maintenance Plan that Checks Database Integrity,
> Reorganizes Index, Rebuilds Index, Update Statistics and Cleans Up
> History.
> If I set the plan to perform these tasks on either All Databases or All
> User
> Databases, will new databases be detected? Or would I need to recreate
> the
> plan any time a new database is added?|||Actually Ekrem .. I found maintenance plans pick up new databases without any
issue without me having to recreate it in 2000 and 2005. But then again I
only use that for backing up ;-).
I have found if I change the maintenace plan name after created it onces,
the jobs don't updated properly. And if I add new tasks then they don't get
reflected properly; but for backups it's been good but it's the nightly full
backups only.
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"Ekrem Ã?nsoy" wrote:
> You'll need to modify your maintanence plan to include the new ones. They'll
> not be added to your old plan automatically.
> However, performing all these jobs (I don't know your schedule however
> something makes me think it's everyday) may not be appropriate for every
> environment.
> It's also not a good idea to include all of these jobs only in one plan as
> one of these jobs would fail, the others after that failed one would not
> work.
> --
> Ekrem Ã?nsoy
>
> "cc.shine" <cc.shine@.discussions.microsoft.com> wrote in message
> news:0011FCDF-395D-4F01-912C-90C189011EBD@.microsoft.com...
> > I've set up a Database Maintenance Plan that Checks Database Integrity,
> > Reorganizes Index, Rebuilds Index, Update Statistics and Cleans Up
> > History.
> > If I set the plan to perform these tasks on either All Databases or All
> > User
> > Databases, will new databases be detected? Or would I need to recreate
> > the
> > plan any time a new database is added?
>|||Actually, it would be the most correct to say new databases would be
included automatically if you do not choose particular databases from the
list and choose All User Databases =)
--
Ekrem Ã?nsoy
"Mohit K. Gupta" <mohitkgupta@.msn.com> wrote in message
news:09E5DB39-C9E5-4D2D-BBF1-AB5303143EFC@.microsoft.com...
> Actually Ekrem .. I found maintenance plans pick up new databases without
> any
> issue without me having to recreate it in 2000 and 2005. But then again I
> only use that for backing up ;-).
> I have found if I change the maintenace plan name after created it onces,
> the jobs don't updated properly. And if I add new tasks then they don't
> get
> reflected properly; but for backups it's been good but it's the nightly
> full
> backups only.
> --
> Mohit K. Gupta
> B.Sc. CS, Minor Japanese
> MCTS: SQL Server 2005
>
> "Ekrem Ã?nsoy" wrote:
>> You'll need to modify your maintanence plan to include the new ones.
>> They'll
>> not be added to your old plan automatically.
>> However, performing all these jobs (I don't know your schedule however
>> something makes me think it's everyday) may not be appropriate for every
>> environment.
>> It's also not a good idea to include all of these jobs only in one plan
>> as
>> one of these jobs would fail, the others after that failed one would not
>> work.
>> --
>> Ekrem Ã?nsoy
>>
>> "cc.shine" <cc.shine@.discussions.microsoft.com> wrote in message
>> news:0011FCDF-395D-4F01-912C-90C189011EBD@.microsoft.com...
>> > I've set up a Database Maintenance Plan that Checks Database Integrity,
>> > Reorganizes Index, Rebuilds Index, Update Statistics and Cleans Up
>> > History.
>> > If I set the plan to perform these tasks on either All Databases or All
>> > User
>> > Databases, will new databases be detected? Or would I need to recreate
>> > the
>> > plan any time a new database is added?