Monday, December 07, 2009

FILESTREAM Data in SQL Server 2008 (ADO.NET)

SQL Server 2008 introduces the FILESTREAM storage attribute for binary (BLOB) data stored in a varbinary (max) column.

SQL Server 2008 introduces two new capabilities for storing BLOB data:

  • FILESTREAM: An attribute you can set on a varbinary column so that the data is stored on the file system (and therefore benefits from its fast streaming capabilities and storage capabilities) but is managed and accessed directly within the context of the database.

  • Remote BLOB Storage (RBS): A client-side application programming interface (API) that is designed to move storage of BLOBs from Microsoft SQL Server to external storage solutions.

See the Video ‘How Do I: Use the Filestream Data Type to Store BLOB Data’

See the links about the File Stream on MSDN,

FILESTREAM Storage in SQL Server 2008

FILESTREAM Data in SQL Server 2008 (ADO.NET)

No comments: