Create a FileStream-Enabled database

Create_FileStreamDb.sql

CREATE DATABASE [Archive] -- CONTAINMENT = NONE
 ON  PRIMARY 
( 
	 NAME = N'Archive'
	,FILENAME = N'C:\data\Archive.mdf' 
	-- ,FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL12.MS_SQL_2014\MSSQL\DATA\Archive.mdf' 
	,SIZE = 4288KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB 
)
,FILEGROUP Archive_FileStreamGroup1 CONTAINS FILESTREAM  DEFAULT
( 
	 NAME = N'Archive_FileStreamGroup1'
	,FILENAME = N'C:\data\Archive_FileStreamGroup1' 
	-- ,FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL12.MS_SQL_2014\MSSQL\DATA\Archive_FileStreamGroup1' 
	,MAXSIZE = UNLIMITED
)
LOG ON 
(
	 NAME = N'Archive_Log'
	,FILENAME = N'C:\data\Archive_Log.ldf' 
	-- ,FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL12.MS_SQL_2014\MSSQL\DATA\Archive_Log.ldf' 
	,SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%
)
GO


-- ==============================================================================================================
-- ==============================================================================================================



-- ===========================================================
-- http://msdn.microsoft.com/en-us/library/cc645585.aspx
-- ===========================================================

CREATE DATABASE Archive 
ON
PRIMARY ( NAME = Arch1,
    FILENAME = 'c:\data\archdat1.mdf'),
FILEGROUP FileStreamGroup1 CONTAINS FILESTREAM( NAME = Arch3,
    FILENAME = 'c:\data\filestream1')
LOG ON  ( NAME = Archlog1,
    FILENAME = 'c:\data\archlog1.ldf')
GO