createdatabaseschoolonprimary(name=data1,filename='D:Sqldatadatagroupdata1.mdf',sizecreatedatabaseschoolonprimary(name=data1,filename='D:Sqldatadatagroupdata1.mdf',size=10,maxsize=100,filegrowth=5),(name=data2,filename='D:S
createdatabaseschoolonprimary(name=data1,filename='D:Sqldatadatagroupdata1.mdf',size
createdatabaseschool
on
primary
(
name=data1,
filename='D:Sqldatadatagroupdata1.mdf',
size=10,
maxsize=100,
filegrowth=5),
(
name=data2,
filename='D:Sqldatadatagroupdata2.ndf',
size=10,
maxsize=100,
filegrowth=5),
filegroupdatagroup
(name=data11,
filename='D:Sqldatadatagroupdata11.ndf',
size=10,
maxsize=100,
filegroup=5),
(name=data21,
filename='D:Sqldatadatagroupdata21.ndf',
size=10,
maxsize=100,
filegroup=5),
logon
(
name=schoollog,
filename='D:Sqldatadatagroupschoollog.ldf',
size=10mb,
maxsize=unlimited,
filegrowth=10%
)
加上单位后服务器:消息155,级别15,状态1,行21
'filegroup'不是可以识别的CREATE/ALTERDATABASE选项.