August 4, 2011 at 9:35 am
Hi all,
I am making a maintenance plan. One of the sub-plans of the maintenance plan is the rebuild of the indexs.
When i added this task i verified that i can check the option of keeping the indexs online while reindexing.
Can someone explain what this option is all about?
Thank you
August 4, 2011 at 9:45 am
Hi ,
I need some inputs from which SQL version are you using ?
SQL server 2005 standard edition won't support online indexing .
August 4, 2011 at 9:58 am
It's SQL2005. But the option is there.... How can not support if the check box is there?
August 4, 2011 at 9:59 am
Sorry i didn't read the message well.
The version is developer edition and in production we have enterprise
August 4, 2011 at 10:08 am
August 5, 2011 at 1:32 am
Ninja's post definitely helps to u...
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply