The link you posted is where I started my research.

Your post indicated that my impression of what is going on with filestream data was wrong. My impression is that the files are not actually stored in the table, however they appear to be stored there as indicated in that blog.

If you run a query on the table, the varbinary(max) field appears to have the file stored in it. However, it is apparently not actually stored in it.

>I have no idea what you are trying to say. Check http://technet.microsoft.com/en-us/library/bb933993%28v=sql.105%29.aspx
>
>>this is the blog that gives me the impression I have:
>>
>>http://www.sqlservercentral.com/blogs/steve_jones/2013/04/25/adding-data-to-filestream-with-t-sql/
>>
>>>When FILESTREAM is used, the files are stored in the file system and table only stores a pointer/reference to it. IOW, if files stored in the table, you are not using FILESTREAM
>>>>
>>>>From my reading it seems that the table appears to have the file stored within it, hence the apparent size of the table, but that is just smoke and mirrors.