SQL server 2008 Filestream

Filestream is a  new feature in SQL server 2008, that allows storage and efficient access to BLOB data, using combination of SQL Server 2008 and NTFS file system.

It provides  an easy way of handling BLOB data with database transactional consistency, integrated management, security and excellent streaming performance.

It basically maintains transactional consistency between the structured and unstructured data.

Some of the highlights:-

  • Different forms of data.
  • Support/Implementation of unstructured data prior to SQL server 2008.
  • Considerations to Store BLOB data
  • Overview of Filestream
  • Limitations of FileStream
  • Enhancements

To watch the video in better quality, please check the link :- https://channel9.msdn.com/posts/SQL-server-2008-Filestream

Presented By: - Keerthi deep ,SE,Microsoft GTSC
Reviewed By: -  Sumit Sarabhai,TL,Microsoft GTSC

Comments (2)

  1. Dinesh Vishe says:

    2 percent processed.

    4 percent processed.

    6 percent processed.

    8 percent processed.

    Msg 3634, Level 16, State 1, Line 1

    The operating system returned the error '32(The process cannot access the file because it is being used by another process.)' while attempting 'OpenFile' on 'E:Microsoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLDATATest_ONLINE.filestreamdata16af32a0-74f5-4513-a8b2-27301072939dc2ed4313-2da4-420d-8dcf-a8c5b02da3240008ecd-000093da-0052'.

    Msg 3013, Level 16, State 1, Line 1

    This error come while backup rstore..

    Need help

  2. Av111 says:

    Got Solution.

    Make antivirsus off.

    update all service patches.

Skip to main content