CREATE DATABASE testbase2
ON
PRIMARY
(NAME=testbase2_prim_sub_dat1,
FILENAME='d:\陈冠希数据库\testbase2_prim_sub1_dat.mdf',
SIZE=5MB,
MAXSIZE=50MB,
FILEGROWTH=20%),
(NAME=testbase2_prim_sub_dat2,
FILENAME='d:\陈冠希数据库\testbase2_prim_sub2_dat.ndf',
SIZE=5MB,
MAXSIZE=50MB,
FILEGROWTH=20%),
FILEGROUP testbase2_Group1
(NAME=testbase2_group1_sub1,
FILENAME='d:\陈冠希数据库\testbase2_group1_sub1_dat.ndf',
SIZE=5MB,
MAXSIZE=50MB,
FILEGROWTH=5MB),
(NAME=testbase2_group1_sub2,
FILENAME='d:\陈冠希数据库\testbase2_group1_sub2_dat.ndf',
SIZE=5MB,
MAXSIZE=50MB,
FILEGROWTH=5MB),
FILEGROUP testbase2_Group2
(NAME=testbase2_group2_sub1,
FILENAME='d:\陈冠希数据库\testbase2_group2_sub1_dat.ndf',
SIZE=5MB,
MAXSIZE=50MB,
FILEGROWTH=15%),
(NAME=testbase2_group2_sub2,
FILENAME='d:\陈冠希数据库\testbase2_group2_sub2_dat.ndf',
SIZE=5MB,
MAXSIZE=50MB,
FILEGROWTH=15%)
LOG ON
(NAME=testbase2_testbase2_log,
FILENAME='d:\陈冠希数据库\testbase2_log_file.ldf',
SIZE=20MB,
MAXSIZE=500MB,
FILEGROWTH=10MB)
GO
08-01
2733