ON PRIMARY
( NAME = SPri1_dat,
FILENAME = 'd:\SPri1dat.mdf' ,
SIZE = 10 ,
MAXSIZE = 50 ,
FILEGROWTH = 15 % ),
( NAME = SPri2_dat,
FILENAME = 'd:\SPri2dt.ndf' ,
SIZE = 10 ,
MAXSIZE = 50 ,
FILEGROWTH = 15 % ),
FILEGROUP SalesGroup1
( NAME = SGrp1Fi1_dat,
FILENAME = 'd:\SG1Fi1dt.ndf' ,
SIZE = 10 ,
MAXSIZE = 50 ,
FILEGROWTH = 5 ),
( NAME = SGrp1Fi2_dat,
FILENAME = 'd:\SG1Fi2dt.ndf' ,
SIZE = 10 ,
MAXSIZE = 50 ,
FILEGROWTH = 5 ),
FILEGROUP SalesGroup2
( NAME = SGrp2Fi1_dat,
FILENAME = 'd:\SG2Fi1dt.ndf' ,
SIZE = 10 ,
MAXSIZE = 50 ,
FILEGROWTH = 5 ),
( NAME = SGrp2Fi2_dat,
FILENAME = 'd:\SG2Fi2dt.ndf' ,
SIZE = 10 ,
MAXSIZE = 50 ,
FILEGROWTH = 5 )
LOG ON
( NAME = 'Sales_log' ,
FILENAME = 'd:\salelog.ldf' ,
SIZE = 5MB ,
MAXSIZE = 25MB ,
FILEGROWTH = 5MB )
GO
===========================================================================
CREATE DATABASE Sales
ON PRIMARY
( NAME = SPri1_dat,
FILENAME = 'd:\SPri1dat.mdf',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 15% ),
( NAME = SPri2_dat,
FILENAME = 'd:\SPri2dt.ndf',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 15% ),
FILEGROUP SalesGroup1
( NAME = SGrp1Fi1_dat,
FILENAME = 'd:\SG1Fi1dt.ndf',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 5 ),
( NAME = SGrp1Fi2_dat,
FILENAME = 'd:\SG1Fi2dt.ndf',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 5 ),
FILEGROUP SalesGroup2
( NAME = SGrp2Fi1_dat,
FILENAME = 'd:\SG2Fi1dt.ndf',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 5 ),
( NAME = SGrp2Fi2_dat,
FILENAME = 'd:\SG2Fi2dt.ndf',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 5 )
LOG ON
( NAME = 'Sales_log',
FILENAME = 'd:\salelog.ldf',
SIZE = 5MB,
MAXSIZE = 25MB,
FILEGROWTH = 5MB )
GO