Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Going Native

By Steve Jones,

I saw a post recently asking about whether or not the general community recommended maintenance plans over custom scripts. My first response was that the plans are limited and custom scripts make more sense, but I started to think about this a little more and I wasn't sure that's the case anymore.

In SS2K5, we got a subsystem based on SSIS that allowed more complex maintenance plans than existed in SQL Server 2000.

Would you recommend maintenance plans or scripts to an intermediate DBA?


Maintenance Plans Wizard

What's your feeling in terms of someone that ought to be comfortable scripting, and understanding scripts they might find on SQLServerCentral. Obviously they should test them, but I know that many people don't, or that they trust scripts because it's got someone's name on it. A maintenance plan, while limited, is "blessed" by Microsoft and built into the product.

For the accidental DBA, what do you recommend and why? I'll say that I tend to push maintenance plans for people that don't know better. They work, and while you can't do everything, at least you can do good, basic maintenance on your SQL Server.

Which I think is better than dropping something there you don't understand, haven't tested, and can't necessarily be sure it works as you need it to work.

Steve Jones

The Voice of the DBA Podcasts

Everyday Jones

The podcast feeds are available at Comments are definitely appreciated and wanted, and you can get feeds from there.

You can also follow Steve Jones on Twitter:

Overall RSS Feed: or now on iTunes!

Today's podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at

I really appreciate and value feedback on the podcasts. Let us know what you like, don't like, or even send in ideas for the show. If you'd like to comment, post something here. The boss will be sure to read it.

Total article views: 116 | Views in the last 30 days: 1
Related Articles

Maintenance Plan Best Practice

Suggestions/Recommendations for Maintenance Plan


Scripting of Maintenance plan

Scripting of Maintenance plan


Podcast Announcements

Podcast Feeds



A new video setup is on the way!!!! Actually I'll do a couple podcasts on podcasting over the hol...



I'm working on getting a small studio set up for some podcasting of the editorials. That means I put...

friday poll    
maintenance plans    

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones