I am trying to run the script below and keep receiving an error message.
"Invalid usage of the option SIZE in the CREATE/ALTER DATABASE statement"
This is from the Microsoft book MCTS: 70-431. Any help is greatly appreciated.
CREATE DATABASE Projects
ON
PRIMARY
(NAME = ProjectPrimary,
FILENAME = 'C:\Projects_Data\ProjectPrimary.mdf'
SIZE = 100MB,
MAXSIZE = 200,
FILEGROWTH = 20),
FILEGROUP ProjectsFG
( NAME = ProjectData1,
FILENAME = 'C:\Projects_Data\ProjectData1.ndf'
SIZE = 200MB,
MAXSIZE = 1200,
FILEGROWTH = 100),
( NAME = ProjectData2,
FILENAME = 'C:\Projects_Data\ProjectData2.ndf'
SIZE = 200MB,
MAXSIZE = 1200,
FILEGROWTH = 100),
FILEGROUP ProjectsHistoryFG
( NAME = ProjectHistory1,
FILENAME = 'C:\Projects_Data\ProjectHistory.ndf'
SIZE = 100MB,
MAXSIZE = 500,
FILEGROWTH = 50)
LOG ON
(NAME = Archlog1,
FILENAME = 'C:\Projects_Data\ProjectLog.ldf'
SIZE = 300MB,
MAXSIZE = 800,
FILEGROWTH = 100)[/size]