Deleting Filestream BLOB and underlying files on filesystem

Hey all

I've deleted rows in my database table, containing a filestream column. My issue is that it does not delete the underlying files on the filesystem, even though MSDN and other sources say that it is supposed to work.

Is there any way that the underlying files can be deleted immediately along with the rows in the database?

Thanks
culminITAsked:
Who is Participating?
 
dportasCommented:
"FILESTREAM garbage collection is a background task that is triggered by the database checkpoint process. A checkpoint is automatically run when enough transaction log has been generated. For more information, see the SQL Server 2008 Books Online topic CHECKPOINT and the Active Portion of the Log (http://msdn.microsoft.com/en-us/library/ms189573.aspx). Given that FILESTREAM file operations are minimally logged in the databases transaction log, it may take a while before the number of transaction log records generated triggers a checkpoint process and garbage collection occurs. If this becomes a problem, you can force garbage collection by using the CHECKPOINT statement."

http://msdn.microsoft.com/en-us/library/cc949109.aspx
0
 
culminITAuthor Commented:
Thank you for your help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.