CREATE DATABASE [CHARACTER_01_DBF]
ON PRIMARY
( NAME = [CHARACTER_01_DBF_Data],
FILENAME = N'C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data\CHARACTER_01_DBF.MDF',
SIZE = 100 MB,
MAXSIZE = UNLIMITED,
FILEGROWTH = 100 MB ),
FILEGROUP [CHARACTER_01_DBF_FG1]
( NAME = [CHARACTER_01_DBF_Data1],
FILENAME = N'C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data\CHARACTER_01_DBF_1.NDF',
SIZE = 100 MB,
MAXSIZE = UNLIMITED,
FILEGROWTH = 100 MB ),
FILEGROUP [CHARACTER_01_DBF_FG2]
( NAME = [CHARACTER_01_DBF_Data2],
FILENAME = N'C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data\CHARACTER_01_DBF_2.NDF',
SIZE = 100 MB,
MAXSIZE = UNLIMITED,
FILEGROWTH = 100 MB ),
FILEGROUP [CHARACTER_01_DBF_FG3]
( NAME = [CHARACTER_01_DBF_Data3],
FILENAME = N'C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data\CHARACTER_01_DBF_3.NDF',
SIZE = 100 MB,
MAXSIZE = UNLIMITED,
FILEGROWTH = 50 MB ),
FILEGROUP [CHARACTER_01_DBF_FGI]
( NAME = [CHARACTER_01_DBF_DataI],
FILENAME = N'C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data\CHARACTER_01_DBF_4.NDF',
SIZE = 100 MB,
MAXSIZE = UNLIMITED,
FILEGROWTH = 50 MB )
LOG ON
( NAME = [CHARACTER_01_DBF_Log],
FILENAME = N'C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data\CHARACTER_01_DBF_5.LDF',
SIZE = 100 MB,
MAXSIZE = 10000 MB,
FILEGROWTH = 10 MB )
COLLATE Latin1_General_BIN