1 Simple Question

Question

1 Simple Question

LearningDBA

SSCertifiable

Points: 6609
More actions
February 6, 2014 at 12:03 pm

#396233

I have to create a maintenance plan for our DEV environment. I am only choosing 2 options 1) Check Database Integrity and 2)Rebuild Indexes. We use 3rd party tool to take backups. My questions is that if it will be OK to create a maintenance plan based on only 2 option or do I have to have a backup as well including in the maintenance plan?
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Sreekanth B SSCertifiable Points: 6145 More actions · Answer 1

It is okay. That works just fine.

BTW, why maintenance Plans for maintaining your indexes? Maintenance plans are not really smart enough IMO. Did you get a chance to look at "Ola Hallengren's Maintenance solution" for performing these tasks for you? That solution is just phenomenal and personally I don't prefer maintenance plans(YMMV).

LearningDBA SSCertifiable Points: 6609 More actions · Answer 2

Well I was just reading Brad M. Mcgehee book and it says how important maintenance plan is for the environment. So, I am just going by what experts have to say!

"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]

Sreekanth B SSCertifiable Points: 6145 More actions · Answer 3

Well, you should see this as well in that case 🙂 Below are the lines from the same Brad in one of his technical articles in SimpleTalk.

"One of the most common ways that DBAs (especially accidental or novice DBAs) create database maintenance plans is to use the Maintenance Plan Wizard from within Management Studio (SSMS). While it is possible to create a decent database maintenance plan using the Maintenance Plan Wizard (see my free eBook: Brad’s Sure Guide to SQL Server Maintenance Plans), the tool is not very flexible, and if it isn’t properly used, it can result in poor database maintenance."

https://www.simple-talk.com/sql/database-administration/automate-and-improve-your-database-maintenance-using-ola-hallengrens-free-script/

Evil Kraig F SSC Guru Points: 100851 More actions · Answer 4

No worries Newborn.

It's not a bash on doing a maintenance plan, it's a bash on the maintenance plan object. It used to be rather buggy and it doesn't have a lot of ability to be selective in what it does.

Scripts like the one pointed out above are very customizable and perform a number of intricate tasks (like not rebuilding indexes under 100 pages because it's pointless, etc) that can be very helpful.

By all means, start with the maintenance plan. Script out the results, see what they're doing. When you get frustrated with it, like many of us have, keep that script above in mind and go check it out. 🙂

- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA

LearningDBA SSCertifiable Points: 6609 More actions · Answer 5

So, what can be done at this point? I don't have any option other than using a Wizard. I don't mind using PowerShell but I am not good with writing scripts.

"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]

LearningDBA SSCertifiable Points: 6609 More actions · Answer 6

I do understand the fact that it will rebuild all the indexes regardless how fragmented they are but my problem is that I am not good with powershell or writing scripts.

"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]

Lowell SSC Guru Points: 323518 More actions · Answer 7

New Born DBA (2/6/2014)
So, what can be done at this point? I don't have any option other than using a Wizard. I don't mind using PowerShell but I am not good with writing scripts.

one of the parameters in the script you'd download from above is to automatically create jobs for you.

so you run the script, and then add a schedule to the new jobs to run when you think is best.

you can always delete any jobs you find confusing or conflicting with your existing jobs.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!