Home Forums SQL Server 2005 Administering Remove a Filegroup RE: Remove a Filegroup
damian-421781
Right there with Babe
Points: 729
More actions
February 11, 2009 at 1:32 am
#941888
To delete a filegroup, you must first delete the file associated with the filegroup.
ALTER DATABASE [your database] REMOVE FILE [filename]
GO
ALTER DATABASE [your database] REMOVE FILEGROUP [filegroupname]