a complete example of the CREATE DATABASE command,
specifying three files and all the properties of each file:
CREATE DATABASE Archive
ON
PRIMARY
( NAME = Arch1,
FILENAME = 'c:\archdat1.mdf',
SIZE = 100MB,
MAXSIZE = 200,
FILEGROWTH = 20),
( NAME = Arch2,
FILENAME = 'c:\archdat2.ndf',
SIZE = 100MB,
MAXSIZE = 200,
FILEGROWTH = 20)
LOG ON
( NAME = Archlog1,
FILENAME =
'c:\archlog1.ldf',
SIZE = 100MB,
MAXSIZE = 200,
FILEGROWTH = 20)