create database school on primary ( name = data1,filename = 'D:\Sqldata\datagroup\data1.mdf',sizecreate database schoolon primary(name = data1,filename = 'D:\Sqldata\datagroup\data1.mdf',size= 10,maxsize=100,filegrowth = 5),(name=data2,filename='D:\S

来源：学生作业帮助网编辑：作业帮时间：2024/11/03 02:23:25

create database school on primary ( name = data1,filename = 'D:\Sqldata\datagroup\data1.mdf',sizecreate database schoolon primary(name = data1,filename = 'D:\Sqldata\datagroup\data1.mdf',size= 10,maxsize=100,filegrowth = 5),(name=data2,filename='D:\S
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 选项.