2.sql

来自「数据库的开发事例」· SQL 代码 · 共 32 行

--指定多个数据文件和日志文件的TEST2，使用三个数据文件和两个日志文件。
create   database    test2
on 
primary
(name=test2_1dat,
 filename='c:\dbtest2003\test21.mdf',
 size = 5MB,
 maxsize=50MB,
 filegrowth=2MB),
(name=test2_2dat,
 filename='c:\dbtest2003\test22.ldf',
 size = 2MB,
 maxsize=50MB,
 filegrowth=2MB),
(name=test2_3dat,
 filename='c:\dbtest2003\test23.ldf',
 size = 3MB,
 maxsize=50MB,
 filegrowth=2MB)

log on
(name=test2_1log,
 filename='e:\db2003\test21.ldf',
 size=5MB,
 maxsize=100MB,
 filegrowth=2MB),
(name=test2_2log,
 filename='e:\db2003\test22.ldf',
 size=3MB,
 maxsize=100MB,
 filegrowth=1MB)