>>Michel, why are you concerned about losing the indexes? Why don't you just let the SQL Server Index
>>Tuning Wizard handle it for you?
>
>Is the SQL Server Index Tuning Wizard able to recognize all existing indexes and apply them? When
>I imported, I lost all indexes I had. How show I proceed to make sure when I import that they are
>being imported as well?
You might not actually want the existing indexes on the back end. The indexes that support Rushmore might be different than the indexes that support your SQL Server optimization. Run some real-world type queries against your data, let SQL Server build the statistics for a bit, and then see what it wants you to have for indexes.