Error Creating New Database - 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

General SQL Server Forums

Database Design and Application Architecture

Error Creating New Database

Author

Topic

youngb912
Starting Member

14 Posts

Posted - 2009-06-16 : 22:25:45

I'm running this command to create a new database but receiving the following error (Msg 153, Level 15, State 1, Line 6
Invalid usage of the option OMB in the CREATE/ALTER DATABASE statement.) -
CREATE DATABASE Sales
ON
PRIMARY
(NAME = SalesPrimary,
FILENAME = 'D:\Sales_Data\SalesPrimary.mdf',
SIZE = 5OMB,
MAXSIZE = 200MB,
FILEGROWTH = 20MB),
FILEGROUP SalesFG
(NAME = SalesData1,
FILENAME = 'C:\Sales_Data\SalesData1.ndf',
SIZE = 20OMB,
MAXSIZE = 800MB,
FILEGROWTH = 100MB),
(NAME = SalesData2,
FILENAME = 'C:\Sales_Data\SalesData2.ndf',
SIZE = 40OMB,
MAXSIZE = 1200MB,
FILEGROWTH = 300MB),
FILEGROUP SalesHistoryFG
(NAME = SalesHistory1,
FILENAME = 'C:\Sales_Data\SalesHistory1.ndf',
SIZE = 10OMB,
MAXSIZE = 500MB,
FILEGROWTH = 50MB),
LOG ON
(NAME = Archlog1
FILENAME = 'F:\Sales_Data\SalesLog.ldf',
SIZE = 300MB,
MAXSIZE = 800MB,
FILEGROWTH = 100MB)

****Any assistance will be appreciated. I can't see where I am going wrong because I'm practically copying the code to the new query screen****.

Again the error code after executing the above query is -
Msg 153, Level 15, State 1, Line 6
Invalid usage of the option OMB in the CREATE/ALTER DATABASE statement.

Thanks,
Blessed

youngb912
Starting Member

14 Posts

Posted - 2009-06-16 : 22:29:39

Issue resolved!
I had use letter o instead of the number 0 in my file size. In addition I had a comma after the log name.

Thanks to anyone who was preparing a response.

Blessed

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources