|
#2
Emory19492011-10-20 15:33
|
程序代码：create database studentcase
on primary
(name='studentcase',
filename='F:\database\stu_group1.mdf',
size=10MB,
maxsize=100MB,
filegrowth=10%),
filegroup stu_group2
(name='stu_group2',
filename='F:\database\stu_group2.mdf',
size=2MB,
maxsize=3MB,
filegrowth=10%)
log on
(name='stu_group2.log',
filename='F:\database\log\stu_group2_log.ldf',
size=1MB,
maxsize=2MB,
filegrowth=10%)
on primary
(name='studentcase',
filename='F:\database\stu_group1.mdf',
size=10MB,
maxsize=100MB,
filegrowth=10%),
filegroup stu_group2
(name='stu_group2',
filename='F:\database\stu_group2.mdf',
size=2MB,
maxsize=3MB,
filegrowth=10%)
log on
(name='stu_group2.log',
filename='F:\database\log\stu_group2_log.ldf',
size=1MB,
maxsize=2MB,
filegrowth=10%)
程序代码：alter database studentcase
add file
(name='stu_file1',
filename='F:\database\stu_file1.ndf',
size=1MB,
maxsize=2MB,
filegrowth=10%)to filegroup stu_group2
alter database studentcase
add filegroup stu_group3
(name='stu_group3',
filename='F:\database\stu_group3.ndf',
size=3MB,
maxsize=1MB,
filegrowth=10%)
运行完前两段代码没问题，可是第三段代码就出现错误了：
消息 102，级别 15，状态 1，第 3 行
'name' 附近有语法错误。
请各位大虾们解决下；谢谢！！！
[ 本帖最后由 wzp630147841 于 2011-10-20 16:02 编辑 ]
.