Is it safe to run MS SQL Maintenance Plan

We have some 2008 SQL databases under a SQL 2008 64-bit. these databases will go to production shortly.

I thought it's a nice idea to schedule Microsoft SQL maintenance plan , Is it safe ? it runs all these integrity checks and shrinking stuff , so I thought I ask an expert.
LVL 10
akhalighiAsked:
Who is Participating?
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Yes, you can..
But as you mentioned that it is PROD server, just make sure that your Maintenance plans runs during off-peak hours to reduce your PROD database load.

>> it runs all these integrity checks and shrinking stuff

Don't ever perform Database shrink operation as is it is not recommended and will

1. Fragment your indexes
2. Reduce your file size which is reserved for future table/database growth increasing fragmentation again
3. Costlier operation
0
 
Éric MoreauSenior .Net ConsultantCommented:
yes it is and it is recommended. you should often check integrity, rebuild indexes, update stats, backup, ...
0
 
CboudrozCommented:
rebuild indexes can lock table for  a long period depending of size of index.

MS SQL 2008 Entreprise can used rebuild index = ONLINE

read this for index rebuild:
http://www.techrepublic.com/blog/datacenter/rebuild-indexes-online-with-sql-server-2005/249
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
akhalighiAuthor Commented:
Alright ... Thanks ...

It looks like that I shouldn't Shrink databases , and I also shouldn't rebuild the indexes. we have SQL 2008 Standard not Enterprise.

So there is nothing much left in a maintenance plan ...

0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
>> It looks like that I shouldn't Shrink databases , and I also shouldn't rebuild the indexes

You need to rebuild indexes but do it during off-peak hours or maintenance window so that your database can perform better.

But never ever do a Shrink database activity as it is totally not recommended.
0
 
akhalighiAuthor Commented:
Yes , the plan is to run these jobs on weekends. do , indexing is okay but shouldn't shrink ...
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Yes, exactly..
Kindly request you to close this question if your doubts are resolved.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.