Please educate the question

arrowhn

create database data1
on
primary
(name = data_m1,
filename = 'e:\sql\data1\data_m1.mdf',
size = 1,
maxsize = 10,
filegrowth = 1),
(name = data_n1,
filename = 'e:\sql\data1\data_n1.ndf',
size = 1,
maxsize = 10,
filegrowth = 10%)
filegroup group1
(name = data_n2,
filename = 'e:\sql\data1\data_n2.ndf',
size = 1,
maxsize = 10,
filegrowth = 1),
log on
(name = data_l1,
filename = 'e:\sql\data1\data_l1.ldf',
size = 1,
maxsize = 10,
filegrowth = 1)
With this statement, appears
Server: Message 170, Level 15, State 1, Line 14
Line 14: Syntax error near 'filegroup'.
Don't know where the problem is, help me

fanfan1980

--try

create database data1
on primary
(name = data_m1,
filename = 'e:\sql\data1\data_m1.mdf',
size = 1,
maxsize = 10,
filegrowth = 1),
(name = data_n1,
filename = 'e:\sql\data1\data_n1.ndf',
size = 1,
maxsize = 10,
filegrowth = 10%),
filegroup group1
(name = data_n2,
filename = 'e:\sql\data1\data_n2.ndf',
size = 1,
maxsize = 10,
filegrowth = 1)

log on
(name = data_l1,
filename = 'e:\sql\data1\data_l1.ldf',
size = 1,
maxsize = 10,
filegrowth = 1)