Create DB with multiple Data Files

CREATE DATABASE YourDb_LIVE
ON PRIMARY
( NAME = YourDB_01,
FILENAME =
'I:\DB\YourDB_01.mdf',
SIZE = 8192,

FILEGROWTH = 5 ),
( NAME = YourDB_02,
FILENAME =
'I:\DB\YourDB_02.ndf',
SIZE = 8192,

FILEGROWTH = 5 ),
( NAME = YourDB_03,
FILENAME =
'I:\DB\YourDB_03.ndf',
SIZE = 8192,


FILEGROWTH = 5 ),
( NAME = YourDB_04,
FILENAME =
'I:\DB\YourDB_04.ndf',
SIZE = 8192,

FILEGROWTH = 5 ),
( NAME = YourDB_05,
FILENAME =
'I:\DB\YourDB_05.ndf',
SIZE = 8192,

FILEGROWTH = 5 ),
( NAME = YourDB_06,
FILENAME =
'I:\DB\YourDB_06.ndf',
SIZE = 8192,

FILEGROWTH = 5 ),
( NAME = YourDB_07,
FILENAME =
'J:\DB\YourDB_07.ndf',
SIZE = 8192,

FILEGROWTH = 5 ),
( NAME = YourDB_08,
FILENAME =
'J:\DB\YourDB_08.ndf',
SIZE = 8192,

FILEGROWTH = 5 ),
( NAME = YourDB_09,
FILENAME =
'J:\DB\YourDB_09.ndf',
SIZE = 8192,

FILEGROWTH = 5 ),
( NAME = YourDB_10,
FILENAME =
'J:\DB\YourDB_10.ndf',
SIZE = 8192,

FILEGROWTH = 5 ),
( NAME = YourDB_11,
FILENAME =
'J:\DB\YourDB_11.ndf',
SIZE = 8192,

FILEGROWTH = 5 ),
( NAME = YourDB_12,
FILENAME =
'J:\DB\YourDB_12.ndf',
SIZE = 8192,


FILEGROWTH = 5 )
LOG ON
( NAME = 'YourDB',
FILENAME =
'X:\Log\YourDB.ldf',
SIZE = 51200MB,

FILEGROWTH = 5MB );
go

alter database YourDB
set single_user with rollback immediate
go

alter database YourDB
collate TURKISH_CI_AS
go

alter database YourDB
set multi_user
go