创建数据库 CREAT DATABASE student ON PRIMARY ( NAME=std_dat1, FILENAME=’d:\data\student1.mdf’, SIZE=10MB, MAXSIZE=200MB, FILEGROWTH=20 ), ( NAME=std_dat2, FILENAME=’d:\data\student2.ndf’, SIZE=10MB, MAXSIZE=200MB, FILEGROWTH=20 ), FILEGROUP business_group ( NAME=business_dat3, FILENAME=’d:\data\businessdat3.ndf’, SIZE=10MB, MAXSIZE=50MB, FILEGROWTH=10% ) LOG ON NAME=business_log, FILENAME=’d:\data\businesslog.ldf’, SIZE=8MB, MAXSIZE=100MB, FILEGROWTH=10MB ) 查看数据库属性 sp_helpdb;查看所有 sp_helpdbstudent查看student数据库属性 添加数据文件和日志文件 ALTER DATABASE sample ADD FILE ( NAME=sample_dat2, FILENAME=’d:\data\sample_dat2.ndf’, SIZE=4, MAXSIZE=10, FILEGROWTH=1 ) ALTER DATABASE sample ADD LOG FILE ( NAME=sample_log2, FILENAME=’d:\data\sample_log2.ldf’, SIZE=4, MAXSIZE=10, FILEGROWTH=1 ) 添加文件组USER1，并向该文件组添加数据文件 ALTER DATABASE sample ADD FILEGROUP USER1 ALTER DATABASE sample ADD FILE ( NAME=sampuser_dat1, FILENAME=’d:\data\sampuser_dat1.ndf’, SIZE=4, MAXSIZE=10, FILEGROWTH=1 ), ( NAME=sampuser_dat2, FILENAME=’d:\data\sampuser_dat2.ndf’, SIZE=4, MAXSIZE=10, FILEGROWTH=1 )TO FILEGROUP USER1 删除数据库中的文件sampuser_dat2 ALTER DATABASE sample REMOVE FLIE sampuser_dat2 删除数据库中的文件组USER1 ALTER DATABASE sample REMOVE FLIE sampuser_dat1 ALTER DATABASE sample REMOVE FLIEGROUP USER1 删除文件组时必须先删除文件组包含的文件，否则报错 本文来源：https://www.wddqw.com/doc/4bb10e0e05087632311212c3.html