balasach82 (2/18/2013)
1. If i had to move a table from a filegroup in drive A back to paimary in drive B, what should i do?
If it's a heap, see my comment above. If its a clustered table then rebuild the clustered index on the target filegroup.
2. A table and its clustered index has to be in same filegroup/same drive?
A clustered index is the table. They are inseparable.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato