Post reply

FILESTREAM and DELETE does not work properly

  • March 10, 2009 at 3:32 am

    #202131

    Hi ya!

    I'm looking at using the new FILESTREAM in 2008.

    Inserts and retrieval work flawlessly. However, when I try execute a DELETE, it seems that only the

    row in the table is deleted and not the underlying binary data?!

    Is there anything that I have overlooked or missed here? I mean, a DELETE is supposed to delete the binary data as well, right?

    Any help on this matter would be greatly appreciated!

    Cheers!

  • March 10, 2009 at 5:57 am

    #956693

    For those of you who are as impatient as me should read this one:

    That solved my question

  • March 10, 2009 at 10:58 am

    #956950

    Boil it down real quick.

    It does delete, however hangs on to it for a bit in the filesystem before it does it, just in case.


    Shamless self promotion - read my blog http://sirsql.net

  • March 10, 2009 at 1:14 pm

    #957029

    There's a garbage collector that cleans up the files later, after it's certain that they're not needed any longer. iirc it runs when the log is truncated ie on log backup or checkpoint depending on recovery model.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 11, 2009 at 5:55 am

    #957372

    Garbage Collector Clean or execute a Checkpoint command.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply