Post reply

Filestream and Recovery Model=FULL

  • May 28, 2009 at 5:07 am

    #204625

    Hi!

    I'm testing the FILESTREAM in SQL Server 2008.

    I had two problems:

    1. When I delete a data base register, with a filestream field inside, the underlying binary data is not deleted.

    2. When I insert a data base register with a filestream field, using Win32 API, appears two files in the filesystem: one of 0Kb, and another that contains the real file.

    I read that the Garbage Collector is the responsible of cleaning these files in the filesystem that are not referenced, and that activates when you make a database backup.

    But when I make a database backup these files are not cleaned.

    My Recovey Model was "FULL".

    Now I had changed may Recovery Model="Simple", so when i make a database backup these files are cleaned.

    The question is: If I want to use the "Full Recovery Model", when is activated the Garbage Collector or how can I activate it?

    Thanks,

    Eva Janakieff

  • May 28, 2009 at 7:13 am

    #1001378

    The garbage collector runs every time a checkpoint runs, however in full, the old doc can't be removed until a log backup has run (not a full DB backup)

    See - http://www.sqlskills.com/BLOGS/PAUL/post/FILESTREAM-garbage-collection.aspx

    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

Viewing 2 posts - 1 through 1 (of 1 total)

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