文件组

/*添加文件组fg*/
ALTER DATABASE test
ADD FILEGROUP fg

/*添加对应的数据文件*/
ALTER DATABASE test
ADD FILE
( NAME = data_file_01,
  FILENAME = 'd:/MSSQL_Data/test_1.ndf',
  SIZE = 300MB,
  MAXSIZE = 8912MB,
  FILEGROWTH = 50MB)
to filegroup fg

ALTER DATABASE test
ADD FILE
( NAME = data_file_02,
  FILENAME = 'd:/MSSQL_Data/test_1.ndf',
  SIZE = 300MB,
  MAXSIZE = 8912MB,
  FILEGROWTH = 50MB)
to filegroup fg

/*删除数据文件*/
ALTER DATABASE test_raid
REMOVE FILE data_file_01

/*删除文件组*/
alter database test_raid
remove filegroup fg