Error:

The filegroup ‘xxxxxx’ cannot be removed because it is not empty.

Fix:

Remember to remove the partition the filegroup belongs to.

DROP PARTITION SCHEME <<PartitionSchemeName>>;
DROP PARTITION FUNCTION <<PartitoinFunctionName>>;
ALTER DATABASE DBNAME
REMOVE FILEGROUP <<PartitionFG>>
Last modified: April 15, 2019

Author

Comments

Write a Reply or Comment