Thanks Andrew. What is typical for a maintenance plan, there are many options
in the Admin. Studio.
I just set one up to:
Check Integrity
Reorg Index
Update Stats
Clean up history
Maintenance Cleanup
By understanding what each option do, you can decide which options are suitable for a particular
installation.
For instance, Maint Cleanup can be critical if you also do backup and don't have other means to
remove old backup files.
Or, Reorg can be important to reduce fragmentation, but since the maint plan's reorg is stupid and
don't take into account initial fragmentation one might want to skip this step and do it yourself
(smarter). Or perhaps not at all, if fragmentation don't cost you.
etc...

Signature
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
> Thanks Andrew. What is typical for a maintenance plan, there are many options
> in the Admin. Studio.
[quoted text clipped - 18 lines]
>> > DPM
>> > ok?
Robert - 02 Mar 2008 16:10 GMT
Thanks Tibor. I will get to reading to better understand what each does.
> By understanding what each option do, you can decide which options are suitable for a particular
> installation.
[quoted text clipped - 29 lines]
> >> > DPM
> >> > ok?