More filegroups than retention configuration, need to remove filegroups

[Levon_Lyons]

The post shows you how to check your file retention setting and then how to remove filegroups if needed. 

View the retention settings. use the following query against BigDataInsightUC:

select * from settings

then you can compare to the filegroup in the database properties of BigDataInsightUC 

Rule of thumb is you will have the Mneht to keep + 2 ( month before and month ahead)

If you need to remove a filegroup manually;

1. Log into SSMS
2. open a new query
3. run the following commands for the file groups identified to be removed
   
   DBCC SHRINKFILE (BigDataInsightUC_201807,EmptyFile)
   ALTER DATABASE [BigDataInsightUC] REMOVE FILE BigDataInsightUC_201807
   
   
4. repeat step 3 for each file group that needs to be removed

SQL references 
- https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-shrinkfile-transact-sql?vi...

- https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql?view=sql-server-ve...