Problem with Creation of a Database

[readyyy]

Hello

I'm currently trying to create my first Database on MS SQL Server 2005. However, when i want to execute the Code, if gives me an error that something with "LOG" is wrong. Also the strange thing is, whe word LOG is written in Pink... does that mean that this keyword is wrong? Here's the Code:

CREATE DATABASE Sales
ON
PRIMARY
(NAME = Sales Primary,
FILENAME = 'D:\Sales_Data\SalesPrimary.mdf',
SIZE = 50MB,
MAXSIZE = 200,
FILEGROWTH = 20),
FILEGROUP SalesFG
(NAME = SalesData1,
FILENAME = 'E:\Sales_Data\SalesData1.ndf',
SIZE = 200MB,
MAXSIZE = 800,
FILEGROWTH = 100),
(NAME = SalesData2,
FILENAME = 'E:\Sales_Data\SalesData2.ndf',
SIZE = 400MB,
MAXSIZE = 1200,
FILEGROWTH = 300),
FILEGROUP SalesHistoryFG
(NAME = SalesHistory1,
FILENAME = 'E:\Sales_Data\SalesHistory1.ndf',
SIZE = 100MB,
MAXSIZE = 500,
FILEGROWTH = 50),
LOG ON
(NAME = Archlog1,
FILENAME = 'F:\Sales_Data\SalesLog.ldf',
SIZE = 300MB,
MAXSIZE = 800,
FILEGROWTH = 100),

 

[mrdenny]

Ditch the comma before LOG ON

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[readyyy]

Now it works! Thanks!

 

[mrdenny]

no problem.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com