ALTER DATABASE (Transact-SQL) File and Filegroup Options Modifies the files and filegroups associated with the database. Adds or removes files and filegroups from a database, and changes the ...

Warning Removing a database file that has FILE_SNAPSHOT backups associated with it will succeed, but any associated snapshots will not be deleted to avoid invalidating the backups referring to the ...