创建数据库DB,具有2个数据文件,文件逻辑名分别为DB_data1和DB_data2,文件初始大小均为5MB,最大为100MB,按10%增长;只有一个日志文件,初始大小为3MB,按10%增长;所有文件都存储在D盘文件夹ceshi中。
create database DB
on
primary
(
name=DB_data1,
filename="d:\ceshi\DB_data1.mdf",
size=5,
filegrowth=10%,
maxsize=100
),
(
name=DB_data2,
filename="d:\ceshi\DB_data2.ndf",
size=5,
filegrowth=10%,
maxsize=100
)
log on
(name=DB_log,
filename="d:\ceshi\DB.ldf",
size=3,
filegrowth=10%,
maxsize=unlimited
)