CREATE DATABASE Archive 
ON
PRIMARY ( NAME = Arch1,
      FILENAME = 'c:\program files\microsoft sql server\mssql\data\archdat1. mdf',
      SIZE = 1MB,
      MAXSIZE =1,
      FILEGROWTH = 1),
( NAME = Arch2,
   FILENAME = 'c:\program files\microsoft sql server\mssql\data\archdat2.ndf',
   SIZE = 1MB,
   MAXSIZE = 1,
   FILEGROWTH = 1),
( NAME = Arch3,
   FILENAME = 'c:\program files\microsoft sql server\mssql\data\archdat3.ndf',
   SIZE = 1MB,
   MAXSIZE = 1,
   FILEGROWTH = 1)
LOG ON 
( NAME = Archlog1,
   FILENAME = 'c:\program files\microsoft sql server\mssql\data\archlog1.ldf',
   SIZE = 1MB,
   MAXSIZE = 1,
   FILEGROWTH =1),
( NAME = Archlog2,
   FILENAME = 'c:\program files\microsoft sql server\mssql\data\archlog2.ldf',
   SIZE = 1MB,
   MAXSIZE = 1,
   FILEGROWTH =1)
GO