【SQL开源代码栏目提醒】:以下是网学会员为您推荐的SQL开源代码-271.sql,希望本篇文章对您学习有所帮助。
Create database DB_SQL
On Primary
( Name=DB_SQL_mdf,
Filename='E:\sql\DB_SQL_data.mdf',
Size=5MB,
Maxsize=50MB,
Filegrowth=5MB
),
( Name=DB_SQL_ndf1,
Filename='E:\sql\DB_SQL_data1.ndf',
Size=3MB,
Maxsize=30MB,
Filegrowth=20%
),
( Name=DB_SQL_ndf2,
Filename='E:\
sql\DB_SQL_data2.ndf',
Size=6,
Maxsize=50,
Filegrowth=4
)
Log on
( Name=DB_SQL_ldf1,
Filename='E:\sql\DB_SQL_log1.ldf',
Size=8MB,
Maxsize=100MB,
Filegrowth=5MB
),
( Name=DB_SQL_ldf2,
Filename='E:\sql\DB_SQL_log2.ldf',
Size=10,
Maxsize=100,
Filegrowth=10
)
GO