作业帮 > 综合 > 作业

create database school on primary ( name = data1,filename =

来源:学生作业帮 编辑:作业帮 分类:综合作业 时间:2024/05/22 09:41:43
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 选项.
size= 10,
maxsize=100,
filegrowth = 5),
等没有单位,应该会影响执行的.
D:\Sqldata\datagroup
目录是否存在也会影响执行的.