3.sql

数据库的开发事例

--使用文件组的TEST3，三个文件组，每个文件组两个数据文件，每个文件组安排在不同的硬盘上。
create   database    test3  on  primary
(name=test3g_1dat,
 filename='c:\dbtest2003\test31.mdf',
 size = 5MB,
 maxsize=50MB,
 filegrowth=2MB),
(name=test3g_2dat,
 filename='c:\dbtest2003\test32.ldf',
 size = 3MB,
 maxsize=50MB,
 filegrowth=1MB),

filegroup  test3fg_2
(name=test3fg_2dat,
 filename='c:\dbtest2003\test3fg21.ldf',
 size = 5MB,
 maxsize=50MB,
 filegrowth=2MB),
(name=test3g_22dat,
 filename='c:\dbtest2003\test3fg22.ldf',
 size = 3MB,
 maxsize=50MB,
 filegrowth=2MB),

filegroup  test3fg_3
(name=test3fg_31dat,
 filename='c:\dbtest2003\test3fg31.ldf',
 size = 2MB,
 maxsize=50MB,
 filegrowth=1MB),
(name=test3fg_32dat,
 filename='c:\dbtest2003\test3fg32.ldf',
 size = 2MB,
 maxsize=50MB,
 filegrowth=1MB)

log on
(name=test31log,
 filename='e:\db2003\test31.ldf',
 size=5MB,
 maxsize=100MB,
 filegrowth=2MB),
(name=test32log,
 filename='e:\db2003\test32.ldf',
 size=5MB,
 maxsize=100MB,
 filegrowth=2MB)