Unused File Group
Each database can have one or more File Groups, each with one or more files in them. Each database object (tables, indexes) is assigned to a file group. If a filegroup doesn't have any objects assigned to it, the files in that filegroup won't be used.
💡 Select 'Suggested Script' for an automatically generated script.
Remove the filegroup and any associated data files.
1. How to Drop Empty Filegroup Data Files.
ALTER DATABASE [WhippetWorks] REMOVE FILE ExtraDataFile;
2. How to Remove Unused Filegroup From the Database.
ALTER DATABASE [WhippetWorks] REMOVE FILEGROUP ExtraFilegroup;
Remove Defunct Filegroups (SQL Server) | Microsoft Docs
ALTER DATABASE (Transact-SQL) File and Filegroup Options | Microsoft Docs