Bhuvnesh (1/16/2013)
Suresh B. (1/16/2013)
However, the filegroup can be different from that of the corresponding tables or other corresponding indexes.What does it mean ?
It means table and index can be reside on different filegroup.
But they must move to thier corresponding filegroup.
For example: Let's say Table1 is on filegroup Data1. And an index called IX_Table1_Name is on filegroup Index1.
They should move to thier corresponding filegroup on the same database.