March 19, 2009 at 5:37 am
Hi,
I've been searching a lot on how to do the OFFLINE rebuild of indexes using the maintenance plan.
I've tried not checking the "Keep Index online while reindexing". I've assumed that this will be kept OFFLINE. but in the summary of the wizard, i noticed that the reindexing is still ONLINE.
can somebody help me with this?
Thanks!:-D
March 19, 2009 at 6:00 am
what i meant for this is
ONLINE=ON
which should be
ONLINE=OFF
how can i do this in maintenance plan wizard?
March 19, 2009 at 8:52 am
ALTER INDEX ‘indexname’ ON ‘tablename’ REBUILD
by default Rebuilding is OFFLINE unless you specify WITH clause as in:
ALTER INDEX ‘indexname’ ON ‘tablename’ REBUILD WITH (ONLINE=ON)
March 19, 2009 at 1:04 pm
also online index rebuilds are a SQL enterprise feature only, it will be ignored if not using enterprise version.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 19, 2009 at 2:08 pm
Give this script a try:
http://blog.ola.hallengren.com/
It runs much quicker than the default maintenance plan and is more configurable.
Also, this is good reading, even if you're not using sharepoint:
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply