数据库开发005创建多数据文件的数据库

create database Archive
on
primary
(name=arch1,
	filename='~\archdat1.mdf',
	size=3mb,
	maxsize=10mb,
	filegrowth=1mb
),
(name=arch2,
	filename='~\archdat2.ndf',
	size=3mb,
	maxsize=10mb,
	filegrowth=1mb
),
(name=arch3,
	filename='~\archdat3.ndf',
	size=3mb,
	maxsize=10mb,
	filegrowth=1mb
)
log on
(name=archlog1,
	filename='~\archlog1.ldf',
	size=1mb,
	maxsize=2mb,
	filegrowth=1mb
),
(name=archlog2,
	filename='~\archlog2.ldf',
	size=1mb,
	maxsize=2mb,
	filegrowth=1mb
)
go