´´½¨SQL ÓÐÎ󣿴íÔÚÄÄÄØ£¿

 
USE master
GO
CREATE DATABASE testbase2
ON
PRIMARY
(NAME = prim_sub_dat1,
FILENAME = 'G:\SQL SERVER2000\prim_sub_dat.mdf',
SIZE = 5MB,
MAXSIZE = 50MB,
FILEGROWTH = 20%),
(NAME = prim_sub_dat2,
FILENAME = 'G:\SQL SERVER2000\prim_sub_dat.ndf'
SIZE = 5MB,
MAXSIZE = 50MB,
FILEGROWTH = 20% ),
FILEGROUP Grouptest1
(NAME = group1_sub1,
FILENAME= 'G:\SQL SERVER2000\group1_sub1_dat.ndf',
SIZE = 5MB,
MAXSIZE = 50MB,
FILEGROUP = 5MB ),
(NAME = group1_sub2,
FILENAME = 'G:\SQL SERVER2000\group1_sub2_dat.ndf',
SIZE = 5MB,
MAXSIZE = 50MB,)
FILEGROUP Grouptest2
(NAME = group2_sub1,
FILENAME = 'G:\SQL SERVER2000\group2_sub1_dat.ndf',
SIZE = 5MB,
MAXSIZE = 50MB,
FILEGROUP = 15%),

(NAME = group2_sub2,
FILENAME = 'G:\SQL SERVER2000\group2_sub2_dat.ndf',
SIZE = 5MB,
MAXSIZE = 50MB,
FILEGROUP =15% )
LOG ON 
( NAME = testbase2_log,
FILENMAE ='G:SQL SERVER2000\testbase2_log_file.ldf',
SIZE  = 5MB,
MAXSIZE = 25MB,
FILEGROUP = 5MB )
GO