Converting Existing table from BLOB to Filestream

1. Create FILESTREAM filegroup. 2. Add FILESTREAM column to table 3.   Choose one of: a. Write an app to select data from the BLOB column and stream it into the FILESTREAM column b. UPDATE <table> SET <filestream_column> = <blob column>; 4. Drop blob column Note: Filestream data is in a separate filegroup, so you can…

1

SQL Server 2008: Filestream Data & Delete Statement

When using Filestream data in SQL Server 2008, you may come across what seems like strange behaviour. This is when you issue a DELETE statement to delete the filestream data, it doesnt actually disappear from the file system. You may ask…why is this? This is essentially because of SQL Server transaction logging mechanism (under full…

1