Use mmk4
go
Create Table mmk4
(Name = mmk24_dat,
Filename='D:\1302120224\test24_dat.mdf',
Size=10Mb,
Filegrowth=10),
Filegroup group24
(Name=test241_dat
Filename='D:\1302120224\test241_dat.ndf',
Size=89,
Maxsize=688,
Filegrowth=10),
(Name=test242_dat,
Filename='D:\1302120224\test992_dat.ndf',
Size=100,
Filegrowth=10%),
Log on
(Name=test24_log,
Filename='D:\1302120224\test24_log.ldf',
Size=10,
Filegrowth=5%)
go
Create Table mmk4
(Name = mmk24_dat,
Filename='D:\1302120224\test24_dat.mdf',
Size=10Mb,
Filegrowth=10),
Filegroup group24
(Name=test241_dat
Filename='D:\1302120224\test241_dat.ndf',
Size=89,
Maxsize=688,
Filegrowth=10),
(Name=test242_dat,
Filename='D:\1302120224\test992_dat.ndf',
Size=100,
Filegrowth=10%),
Log on
(Name=test24_log,
Filename='D:\1302120224\test24_log.ldf',
Size=10,
Filegrowth=5%)
给你个实例,创建数据库的SQL,供你参考! create database stuDB
on primary -- 默认就属于primary文件组,可省略
(
/*--数据文件的具体描述--*/
name='stuDB_data', -- 主数据文件的逻辑名称
filename='D:\stuDB_data.mdf', -- 主数据文件的物理名称
size=5mb, --主数据文件的初始大小
maxsize=100mb, -- 主数据文件增长的最大值
filegrowth=15%--主数据文件的增长率
)
log on
(
/*--日志文件的具体描述,各参数含义同上--*/
name='stuDB_log',
filename='D:\stuDB_log.ldf',
size=2mb,
filegrowth=1mb
)
Create Table my_test99
On Primary
(Name=test99_dat,
Filname=“D:\99999\ test99_dat.mdf”,
Size=10Mb,
Filegrewth=10)
Filegroup group99
(Name=test991_dat
Filename=“D:\99999\test991_dat.mdf”,
Size=89,
Maxsize=688,
Filegrowth=10)
(Name=test992_dat,
Filename=“D:\99999\test992_dat.ndf”,
Size=100,
Filegrowth=10%),
Log in
(Name=test99_log,
Filename=“D:\99999\test99_log.ldf”,
Size=10,
Filegrowth=5%)
Use my_test99
go
Use master
go
Create DATABASE my_test99
On Primary
(Name=test99_dat,
FilEname='D:\99999\test99_dat.mdf',
Size=10Mb,
filegrowth=10)
,Filegroup group991
(Name=test991_dat,
Filename='D:\99999\test991_dat.mdf',
Size=89,
Maxsize=688,
Filegrowth=10)
,Filegroup group992
(Name=test992_dat,
Filename='D:\99999\test992_dat.ndf',
Size=100,
Filegrowth=10%)
Log On
(Name=test99_log,
Filename='D:\99999\test99_log.ldf',
Size=10,
Filegrowth=5%)
on primary
(Name=test24_dat,
Filename='D:\1302120224\test24_dat.mdf',
Size=10Mb,
Filegrowth=10),
Filegroup group241
(Name=test241_dat,
Filename='D:\1302120224\test241_dat.ndf',
Size=89,
Maxsize=688,
Filegrowth=10),
Filegroup group992
(Name=test992_dat,
Filename='D:\1302120224\test992_dat.ndf',
Size=100,
Filegrowth=10%)
Log on
(Name=test24_log,
Filename='D:\1302120224\test24_log.ldf',
Size=10,
Filegrowth=5%)
On Primary
(Name=test99_dat,
FilEname='D:\99999\test99_dat.mdf',
Size=10Mb,
filegrowth=10)
,Filegroup group991 --将下面的数据文件test991_dat指定到该文件组中,默认为primary文件组
(Name=test991_dat,
Filename='D:\99999\test991_dat.mdf', --数据文件所在路径
Size=89,
Maxsize=688,
Filegrowth=10)
,Filegroup group992 --同上述解释
(Name=test992_dat,
Filename='D:\99999\test992_dat.ndf',
Size=100,
Filegrowth=10%) --增长速率有两个单位 mb为默认,也可以为百分比
Log On --指定日志文件,日志文件不属于任何文件组
(Name=test99_log,
Filename='D:\99999\test99_log.ldf',
Size=10,
Filegrowth=5%)