FILESTREAM is a new feature of SQL Server 2008 that supports BLOB [Binary Large Objects] file storage on NTFS file shares managed by SQL Server. The FILESTREAM feature is disabled during the default SQL Server 2008 installation.
To enable FILESTREAM feature on SQL Server 2008,
- Open SQL Server Configuration Manager (Start > Programs > Microsoft SQL Server 2008 > Configuration Tools > SQL Server Configuration Manager)
- Navigate to the SQL Server Services node and select the SQL Server instance you want to modify SQL Server (MSSQLSERVER)
- Click the FILESTREAM tab and select the checkboxes to enable FILESTREAM and enter a share name for the files, as shown
.png)
