/*添加文件组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