createdatabaseschoolonprimary(name=data1,filename='D:\Sqldata\datagroup\data1.mdf',sizecreatedatabaseschoolonprimary(name=data1,filename='D:\Sqldata\datagroup\data1.mdf',size=10,maxsize=100,filegrowth=5),(name=data2,filename='D:\S

Question

create database school on primary ( name = data1,filename = 'D:\Sqldata\datagroup\data1.mdf',size
create database school
on
primary
(
name = data1,
filename = 'D:\Sqldata\datagroup\data1.mdf',
size= 10,
maxsize=100,
filegrowth = 5),
(
name=data2,
filename='D:\Sqldata\datagroup\data2.ndf',
size=10,
maxsize=100,
filegrowth=5),
filegroup datagroup
(name=data11,
filename='D:\Sqldata\datagroup\data11.ndf',
size=10,
maxsize=100,
filegroup=5),
(name=data21,
filename='D:\Sqldata\datagroup\data21.ndf',
size=10,
maxsize=100,
filegroup=5),
log on
(
name = schoollog,
filename ='D:\Sqldata\datagroup\schoollog.ldf',
size=10mb,
maxsize =unlimited,
filegrowth =10%
)
加上单位后 服务器:消息 155,级别 15,状态 1,行 21
'filegroup' 不是可以识别的 CREATE/ALTER DATABASE 选项.

Answer 1

size= 10,
maxsize=100,
filegrowth = 5),
等没有单位,应该会影响执行的.
D:\Sqldata\datagroup
目录是否存在也会影响执行的.