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:-
To watch the video in better quality, please check the link :- http://channel9.msdn.com/posts/SQL-server-2008-Filestream
Presented By: - Keerthi deep ,SE,Microsoft GTSCReviewed By: - Sumit Sarabhai,TL,Microsoft GTSC
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 Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Test_ONLINE.filestreamdata\16af32a0-74f5-4513-a8b2-27301072939d\c2ed4313-2da4-420d-8dcf-a8c5b02da324\00008ecd-000093da-0052'.
Msg 3013, Level 16, State 1, Line 1
This error come while backup rstore..