Listing 1: Creating a Database that Uses FILESTREAM Objects

CREATE DATABASE MyFileStreamDB ON PRIMARY
  ( NAME = FileStreamDB_data,
    FILENAME = N'C:\FileStream\MyFSDB_data.mdf',
    SIZE = 10MB,
    MAXSIZE = 50MB,
    FILEGROWTH = 15%),
	FILEGROUP MyDBData
  ( NAME = MyFileStream_group,
    FILENAME = N'C:\FileStream\MyFSDB_stream.ndf)',
    SIZE = 10MB,
    MAXSIZE = 50MB,
    FILEGROWTH = 5MB),
FILEGROUP MyFileStreamGroup1 CONTAINS FILESTREAM
  ( NAME = MyFileStream,
    FILENAME = N'C:\FileStream\MyFSData')
LOG ON
  ( NAME = 'MyFSDB_log',
    FILENAME = N'C:\FileStream\MyFSDB_log.ldf',
    SIZE = 5MB,
    MAXSIZE = 25MB,
    FILEGROWTH = 5MB);