LOG ON 的错误

Question

在sql server 2005中的源代码：
create database sales
on
primary
(name=salesprimary,
filename='C:\ed\salesprimary.mdf',
size=3mb,
maxsize=20mb,
filegrowth=1mb),
filegroup salesfg
(name=data1,
filename='C:\ed\data1.ndf',
size=1mb,
maxsize=20mb,
filegrowth=1mb),
(name=data2,
filename='C:\ed\data2.ndf',
size=1mb,
maxsize=20mb,
filegrowth=1mb),
filegroup salesdata
(name=salesdata,
filename='C:\ed\salesdata.ndf',
size=1mb,
maxsize=20mb,
filegrowth=1mb),
Log on
(name=saleslog,
filename='C:\ed\saleslog.ldf',
size=1mb,
maxsize=20mb,
filegrowth=1mb)
go错误为：
消息 102，级别 15，状态 1，第 26 行
'Log' 附近有语法错误。
高手帮看看？？？？
在线=====啊

Answer 1

create database sales
on
primary
(name=salesprimary,
filename='C:\ed\salesprimary.mdf',
size=3mb,
maxsize=20mb,
filegrowth=1mb),
filegroup salesfg
(name=data1,
filename='C:\ed\data1.ndf',
size=1mb,
maxsize=20mb,
filegrowth=1mb),
(name=data2,
filename='C:\ed\data2.ndf',
size=1mb,
maxsize=20mb,
filegrowth=1mb),
filegroup salesdata
(name=salesdata,
filename='C:\ed\salesdata.ndf',
size=1mb,
maxsize=20mb,
filegrowth=1mb) ---- no comma
Log on
(name=saleslog,
filename='C:\ed\saleslog.ldf',
size=1mb,
maxsize=20mb,
filegrowth=1mb) 

Answer 2

谢谢
自己解决了
是日志文件必须要有_log的后缀

Answer 3

filegrowth=1mb), 
这句多个逗号吧

Answer 4

log on 前面的逗号应去掉