maintenance plan, best practices

[ersatz]

Hi,

For sql server 2000 I never used the maintenance plan, I always used jobs to solve my maintenance problems.

This year I will migrate to the 2005 version and I would like to know if you already used that, if the maintenance plan is stronger, because I do not find information concerning the best practices.

Thank you very much for your comments, suggestions and… sorry for my english

 

[SQLBill]

We use the maintenance plans for both 2000 and 2005, just because that is the procedure set up where I work. They found it easier than scripting it for each server/database. I don't know that it is 'stronger'...depends on what YOU mean by that. It is easier to script each portion separately and place them in whatever order you wish.

-SQLBill

Posting advice: FAQ481-4875

 

[Catadmin]

There are currently some issues with the 2005 integrity check plans (or at least, I'm running into issues) that promise to be resolved with SP2. But other than that, I think the 2005 plans seem to be much better, and have more options, than SQL 2000.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[ersatz]

Many thanks for your comments.
I will try the new MP.