Database Engine Configuration - Filestream
TOC
Collapse the table of content
Expand the table of content

Database Engine Configuration - Filestream

 

Applies To: SQL Server 2016

Use this page to enable FILESTREAM for this installation of SQL Server 2016. FILESTREAM integrates the SQL Server Database Engine with an NTFS file system by storing varbinary(max) binary large object (BLOB) data as files on the file system. Transact-SQL statements can insert, update, query, search, and back up FILESTREAM data. Win32 file system interfaces provide streaming access to the data.

Enable FILESTREAM for Transact-SQL access
Select to enable FILESTREAM for Transact-SQL access. This control must be checked before the other control options will be available.

Enable FILESTREAM for file I/O streaming access
Select to enable Win32 streaming access for FILESTREAM.

Windows share name
Use this control to enter the name of the Windows share in which the FILESTREAM data will be stored.

Allow remote clients to have streaming access to FILESTREAM data
Select this control to allow remote clients to access this FILESTREAM data on this server.

Enable and Configure FILESTREAM
sp_configure (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft