Wednesday, June 1, 2011

Drawback of Miantenance Plans compared to SP's

·         Not advisable for complex tasks.
·         If mixed recovery models on one server it’s much easier to use t-sql scripts than maintenance plans.
·         Difficult to us in database mirroring. As MP’s
·         Consistency between sql versions.
·         Time window logic is much easier in t-sql scripts than MP’s. Like after full bckup if enough time is there then if planning to perform defragmentation and so on..

No comments:

Post a Comment