June 24, 2009 at 10:03 am
I would like to set up DB Maintance plan for Optimization and Integrity, which options in DB Maintance plan should I choose.In 2000 I was ok,but in 2005 very confusing. I already have backup job running seperatly and what else you think I should add in there. Thank you
June 24, 2009 at 10:08 am
Answer: check database integrity task:
but here is how you should form the maintenance plan:
BAckup Database Task:
Maintenance Cleanup
history cleanup
if required seprate out the integrity checks and index rebuild tasks in another maintenance plan.
Maninder
www.dbanation.com
June 24, 2009 at 11:16 am
Ok for the system and db should I have the same things check?Do I need to check Update statistics?Is Database integrity task takes care of integrity and optimization together because in 2000 they have it seperate
Here is the way I understand, create 2 maintance plan check the following:
BAckup Database Task:
database integrity task
Maintenance Cleanup
history cleanup
Thank you
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply