注册 登录
编程论坛 SQL Server论坛

消息 153,级别 15,状态 1,第 14 行 在 CREATE/ALTER DATABASE 语句中选项 FILEGOWTH 的用法无效。

蜡笔小新857 发布于 2021-01-14 10:41, 2231 次点击
CREATE DATABASE Exercise_db4
/*创建主文件组*/
ON
PRIMARY
(NAME=Exe4_1_dat,
FILENAME='C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\Exe4_F1dat.MDF',
SIZE=10,
MAXSIZE=Unlimited,
FILEGROWTH=10%),
(NAME=Exe4_2_dat,
FILENAME='C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\Exe4_F2dat.NDF',
SIZE=15,
MAXSIZE=50MB,
FILEGOWTH=1),
/*创建文件组*/
FILEGROUP Exe4_Group1
(NAME=E4_G1_F1_dat,
FILENAME='C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\Exe4_G1F1dat.NDF',
SIZE=10,
MAXSIZE=Unlimited,
FILEGROWTH=15%),
(NAME=E4_G1_F2_dat,
FILENAME='C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\Exe4_G1F2dat.NDF',
SIZE=10,
MAXSIZE=Unlimited,
FILEGROWTH=3)
/*创建事务日志文件*/
LOG ON
(NAME=Exe4_LOG,
FILENAME='C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\Exe4log.LDF',
SIZE=5,
MAXSIZE=35,
FILEGROWTH=5)
0 回复
1