don't mind maintenance plans for backups, they do those fairly well. I do not like them for DBCCs, and it seems that most of the maintenance plans that I see people want them to do everything. That's fine, as far as it goes, but I want more details. I do full DBCCs every work night on everything (sp_msforeachdb, except for one server) via OSQL and send the results to a text file. I have an aging system to keep the last ten runs. I then pipe the results through Find looking for "errors" and that file is grabbed by a nightly Perl script so that I see a couple of dozen lines of DBCC results rather than thousands of lines. If I see non-zero numbers in that result set, I can probe deeper into the full file that's on the server.
Steve Jones - Editor (1/15/2009)
Review? Source Code? It's this point and click?!?!? 😛The only place I used maintenance plans is when I don't have time to set something up or someone has installed their own instance and needs something setup. Easier to get them to do a maintenance plan at first and handle things rather than nothing.
Wayne,
Just to help you right. By salted (remember I am an Afrikaans (Dutch) speaking South African) I actually meant knowledgable or trained. Salted is a word we Afrikaners use to say that and not old or aged. Would you guys mind to post some of these scripts that you use and how do you schedule them to run on their own. I don't see you sitting their every night running all these scripts. Please help a wannabe DBA out will you or refer me to an article on SSC where I can learn that.
I'll appreciate that very much.:alien:
:-PManie Verster
Developer
Johannesburg
South Africa
I can do all things through Christ who strengthens me. - Holy Bible
I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)