Periodic cleaning up for files created by SQL filestream.
Posted on 2011-09-23
I added a filestream column in one of the sql tables.
I am storing word documents into that column - from the web using ASP.net functions.
I am able to store and retrieve the files from the filestream column. My concern is that, every time I add or modify the files, it creates lots of physical files in the associated folder. Is there a best way to periodically cleanup theose files (that were created as part of the filestream).
I found few methods from my search. But most of them are unclear.