March 26, 2010 at 8:40 am
I have been testing an SSIS application that, amoung other things, stores report files as FILESTREAM data. I've got about 12,000 files in many folders under the default FS folder on my C drive and would like to get rid of them. I tried deleting all of the rows from a table then issuing a CHECKPOINT and also truncating a table and issuing a CHECKPOINT command but neither approach eliminated any of the blobs stored in the FS folder.
December 16, 2010 at 8:29 am
Im struggling with the same thing right now... any answers? Delete from table, does not delete physical file. Update of record creates an additional file........ and no clean up (as yet).
Also if you look at a record in a table, how to you link that record and the file stored??
December 16, 2010 at 8:40 am
Ok, found out about the garbage collector taking some time to complete the deletes, etc
Still looking for the "link" between the record and the physical file?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply