sqlserver2012从入门到精通代码

/*创建数据库*/

use master;

create database test
on primary
(NAME='TESTDB',FILENAME='D:\SQL SERVER\WORKSPLACE\TEST.MDF',SIZE=10MB,MAXSIZE=20,
FILEGROWTH=10%)
LOG ON
(NAME='TESTLOG',FILENAME='D:\SQL SERVER\WORKSPLACE\TEST.LDF',SIZE = 10MB

,FILEGROWTH = 2);

/*添加次要文件*/

USE MASTER;
ALTER DATABASE TEST
ADD FILEGROUP GROUP2;
ALTER DATABASE TEST
ADD FILE(NAME='TEST2',FILENAME='D:\SQL SERVER\WORKSPLACE\SECONDFILE2.NDF',
SIZE=10,MAXSIZE=20,FILEGROWTH=10%)
TO FILEGROUP GROUP2;