2.sql

数据库的开发事例

--指定多个数据文件和日志文件的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)