Create Table On Filegroups

CREATE DATABASE Dummy

ON



PRIMARY (

NAME = PrimaryLog,

FILENAME = 'D:primary.mdf',

SIZE = 5MB,

MAXSIZE = 500MB,

FILEGROWTH = 20MB ),

(

NAME = Data,

FILENAME = 'D:Data.ndf',

SIZE = 5MB,

MAXSIZE = 500MB,

FILEGROWTH = 20MB ),

LOG ON

-- Stores The Log Information used To Recover The Database

(

NAME = Log,

FILENAME = 'D:Log.ldf',

SIZE = 5MB,

MAXSIZE = 500MB,

FILEGROWTH = 20MB )

Go









After this I want to create table on Data .



CREATE TABLE Sample (

No INT ,Name VARCHAR(30) , Department VARCHAR(4000) NULL

)

ON Data

GO



it shows invalid filegroup DATA specified



what may be wrong