How can I rebuild ALL indexes at once.

A restore of a recent backup of SQL and your index volumes will expedite the situation.

Thanks Nue.

I should have said though, that I am doing this to change the Index level from Brief to Full.. So need to rebuild all the current Indexes. I have had a look, and have come up with the following..

Reset all the failed states, to 1 in the IndexVolume Table. (Via SQL Query Analyser) This then lets you search for all failed indexes in IndexVolumeReplay, and rebuild each one .. One at a time... :( Not ideal, but the only way I can find to do it.......

There should be no need to do this. Simply resetting the indexing level will cause an automatic rebuild of the indexes.



> Thanks Nue.
>
> I should have said though, that I am doing this to
> change the Index level from Brief to Full.. So need
> to rebuild all the current Indexes. I have had a
> look, and have come up with the following..
>
> Reset all the failed states, to 1 in the IndexVolume
> Table. (Via SQL Query Analyser) This then lets you
> search for all failed indexes in IndexVolumeReplay,
> and rebuild each one .. One at a time... :(
> Not ideal, but the only way I can find to do
> it.......

The Website has a Document ( http://support.veritas.com/docs/273234 ) and this is from that doc.

To change the indexing level for a mailbox that is already enabled, you will need to first select the new level from the archive's advanced property page. Next, you must rebuild the whole index. Please see the related document for how to rebuild an index.

So I am thinking, that even if you change the Site level Indexing, all new Indexes will inherit that setting, but Current indexes will not.. (New items added into old indexes will be at the new level? )

Can anyone verify my thinking...

Bob,
I'm with you on this one. I've never seen the indexes rebuild or degrade if you set the level differently (from full to brief, or viceversa). The same seems to go for retention categories, which is why Sym. recommends doing a restore before you re-retention.

micah

No simply resetting the index won't tick off a rebuild. However, from that point forward all items will be indexed with the new level, maybe that's what Nue was thinking?

Yeah,
EV is one of the few products I know of that if you don't set it up the right way the first time, ya sorta boned. here's for hopin' stuff like this gets better in 7.

micah

You could just simple delete all the indexes or rename there folder location and create a new folder with the same name and then initate an archive run now for 1 item on all mailboxes. This will cause all the indexes to be rebuilt. Not sure if you would want to do all 500 at once, but that would do it.

Would that really recreate them all?

micah