Very basic query - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Very basic query

Author

Topic

quinla01
Starting Member

2 Posts

Posted - 2007-08-30 : 10:05:29

Hi Guys,

I've Just started on my journey to become an sql boffin as our sql administrator has pretty much dropped dead. I've got to page 61 of the book and its asking me to create a database using the code below however when i try and execute the query i get the following message.

=====================================
Msg 102, Level 15, State 1, Line 31
Incorrect syntax near 'LOG'.
=====================================

All i can really tell you at this point is that the disks are configured correctly, and i'm running it of a 2003 box.

Any help much appreciated.

Thanks a lot,

Andrew

CREATE DATABASE Sales
ON

Primary
(name=SalesPrimary,
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)

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2007-08-30 : 10:11:25

you have a comma too many ...

...
....
filegrowth=50)

LOG ON
...
...