sql中创建一个数据库，要求创建两个数据文件，格式怎么写啊，用什么连接，初学者想请教下高手指点，非常感

Question

下面是我写的，我不知道第二数据文件与第一个数据文件连接的时候是不是那样，老是提示是第二个name那附件有语法错误：
create database Db
on
(name=DB_data1,
filename="d:\ceshi\DB_data1.mdf",
size=5Mb,
filegrowth=10%,
maxsize=100Mb )

(name=DB_data2,
filename="d:\ceshi\DB_data2.ndf",
size=5Mb,
filegrowth=10%,
maxsize=100Mb
)
log on
(name=DB_log,
filename="d:\ceshi\Db.ldf",
size=3Mb,
filegrowth=10%,
maxsize=unlimited
)

Answer 1

create database Db
on
primary ------------------------这里加primary
(name=DB_data1,
filename="d:\ceshi\DB_data1.mdf",
size=5Mb,
filegrowth=10%,
maxsize=100Mb )
,---------------------------------这里加斗号
(name=DB_data2,
filename="d:\ceshi\DB_data2.ndf",
size=5Mb,
filegrowth=10%,
maxsize=100Mb
)
log on
(name=DB_log,
filename="d:\ceshi\Db.ldf",
size=3Mb,
filegrowth=10%,
maxsize=unlimited
)

参考资料：http://msdn.microsoft.com/zh-cn/library/ms176061.aspx

本回答被提问者采纳

Answer 2

create database Db
on PRIMARY
(name=DB_data1,
filename="d:\ceshi\DB_data1.mdf",
size=5Mb,
filegrowth=10%,
maxsize=100Mb ) ,
FILEGROUP [SECONDARY]
(name=DB_data2,
filename="d:\ceshi\DB_data2.ndf",
size=5Mb,
filegrowth=10%,
maxsize=100Mb
)
log on
(name=DB_log,
filename="d:\ceshi\Db.ldf",
size=3Mb,
filegrowth=10%,
maxsize=unlimited
)