Moving a table with LOB from one Filegroup to another
Posted on 2010-01-06
I have a table with an image datatype (i.e. a LOB).
I'd like to move this table from one filegroup to another, dedicated to this table alone.
I have done this by dropping the primary key index and re-creating on the new filegroup.
sp_help now reports the table as being on that filegroup.
However, sp_spaceused for the table shows around 124Mb (test database) and the file for that filegroup is only 50Mb. So I presume this didn't move all the data.
I have tried reorganise indexes, and rebuild stats.
Have I missed something? I'd like to get this right before I move on to production databases where this table represents several GB of data.