We have a db table which contained a large amount of documents. These documents have now been stripped out and as this table will never grow to this size again we are looking to claim back this space.
From reading up on this the best solution appears to be:
Create new filegroup (called secondary-we currently only have primary)
Move all user tables into this new filegroup by dropping and recreating the clustered index
Is this the best solution? I assume I would then need to shrink the primary filegroup? Is so, what's the best way to do this?
Many thanks Paul