Create a database

The “CREATE DATABASE <Database Name>” will impact to database performance issue if it’s not utilize properly.

There are many articles has discussed and posted.

I would recommend to issues a complete a statement instead of CREATE DATABASE <Database Name> :

CREATE DATABASE BearCreek ONPRIMARY

(NAME =N’BearCreek_Data’,FILENAME=N’M:\SQL_Data\BearCreek.mdf’,

SIZE= 8MB, MAXSIZE =UNLIMITED, FILEGROWTH = 16MB),

FILEGROUP FG1

(NAME =N’BearCreek_Data2′,FILENAME=N’M:\SQL_Data\BearCreek.ndf’,

SIZE= 8MB, MAXSIZE =UNLIMITED, FILEGROWTH = 16GB),

FILEGROUP BearCreekDocuments

CONTAINSFILESTREAMDEFAULT

(NAME =N’BearCreekDocuments’,FILENAME=N’M:\SQL_Data\BearCreekDocuments’)

LOG ON

(NAME =N’BearCreek_Log’,FILENAME=‘L:\SQL_Log\BearCreek.ldf’,

SIZE= 8MB, MAXSIZE =UNLIMITED, FILEGROWTH = 16MB)

ALTER DATABASE BearCreek

MODIFY FILEGROUP FG1

DEFAULT

SQL INDONESIA