Have created a new filegroup for a database and want to move a table called "Pictures" from the primary filegroup to the new "Pictures" filegroup.
Dont know how to move the specific table to the new filegroup. I have done some googling and can see that I have to move the Index.
In SQL Server Management Studio I navigate to server / Databases / Mydatabase/ Tables/ Pictures / Indexes:
I see the following three indexes:
IxTblPictures (Non-Unique, Non-Clustered)
IxTblPictures1 (Non-Unique, Non-Clustered)
If I right click/properties on the clustered index and select Storage in the left pane, then the right pane is grayed out, so I cannot choose the new filegroup. WHY???
On the Non-Unique, Non-Clustered indexes I can change settings in the right pane under Storage.
I have never tried this before. Am I on the right track or is there a better way of moving a table to another file group.