Updated 3x

I'm using FILESTREAM, but am having an issue with garbage collection. The FILESTREAM files are not being cleaned up when I set the column to null.

  • In the event log, there is an enormous number of this error: Internal FILESTREAM error: failed to access the garbage collection table.

  • It is error number 5571 on this page: http://msdn.microsoft.com/en-us/library/cc645602.aspx

  • Using this blog post I've confirmed that a 'tombstone' table exists, but I cannot query it (Invalid object name 'sys.filestream_tombstone_xxxxxxx'.)

  • I'm not deleting rows, I'm setting the FILESTREAM column to null, as per this msdn article: "When a FILESTREAM field is set to NULL, the BLOB data associated with the field is deleted."

  • The database is on a local drive.

  • The database is using Simple Recovery.

  • I have executed a number of CHECKPOINTs when activity was very low. This seems to have done nothing. The error message seems to indicate the FILESTREAM garbage collector is trying to garbage collect, but cannot access the table to find out what to do.

  • SQL Server 2008 (10.0.2531.0, SP1, Enterprise Edition

  • There are no other errors preceding the 5571 errors that I can see in the SQL Server Log or Event Log.


There was an error detected. What do I do about this?

DBCC results for 'sys.filestream_tombstone_1819153526'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'sys.filestream_tombstone_1819153526' (ID 1819153526). Data row does not have a matching index row in the index 'FSTSNCIdx' (ID 2). Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:4712151:3) identified by (oplsn_fseqno = 62856 and oplsn_bOffset = 82647 and oplsn_slotid = 2) with index values 'file_id = 65537 and rowset_guid = '3F972309-9B0B-4C4F-939A-5618897050B4' and column_guid = '4A143C0D-B877-494E-B1E6-B70B0A834BB6' and oplsn_fseqno = 62856 and oplsn_bOffset = 82647 and oplsn_slotid = 2'.
There are 209624 rows in 3382 pages for object "sys.filestream_tombstone_1819153526".


  • How should permissions be set up for FILESTREAM to work? Other people have access to this server, and this database may have been restored from a backup at some point.

  • How do I check FILESTREAM (Windows) share/container account permissions and account under which SQL Server runs?

Thanks to @vgv8 for prompting for more info and ideas.

  • 2 questions: Which version of Sql Server are you using? Are there any other error messages preceding the 5571 errors (I believe there should be)
    – Pawel Marciniak
    Dec 8, 2010 at 19:09
  • I also would look into corresponding events in eventvwr.msc
    – WebMAOhist
    Dec 8, 2010 at 19:25
  • more info here: social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/…
    – cofiem
    Dec 14, 2010 at 23:43
  • the main solution is to make the database as simple recovery mode :)
    – user7607
    Mar 22, 2012 at 15:06
  • – cofiem,did you find any solution to this Issue ? Please do share how to deal with issue --- failed to access the garbage collection table. Event ID 5571,Thanks May 19, 2016 at 7:38

1 Answer 1


It seems like insufficient info to tell something definitely. For example, are you deleting through Transact-SQL or through Win32API, etc.

The FILESTREAM data is not deleted immediately from file system because SQL Server transaction logging under full and bulk recovery models permit the crash recovery.

Have you deleted with CHECKPOINT

delete from tablename CHECKPOINT

or tried to execute CHECKPOINT statement or use simple recovery model?

Also, IMO,:

  • changing of FILESTREAM (re)configuration require restart of SQL Server
  • FILESTREAM data is restricted to LOCAL only drives
  • FILESTREAM operations depend on hardware, see Paul Randal's white paper
  • "deleting or renaming any FILESTREAM files directly through the file system will result in database corruption"

Check Security and Reliability sections of Paul Randal's white paper

Related discussions containing many subreferences:

Have you checked permissions of FILESTREAM (Windows) share/container vs. account under which SQL Server runs under. It should have local administrator permissions. It is recommended that no other account be granted permissions on the data container

From Paul Randal's white paper:

  • "The file system access open operations do not wait for any locks. Instead, the open operations fail immediately if they cannot access the data because of transaction isolation. The streaming API calls fail with ERROR_SHARING_VIOLATION if the open operation cannot continue because of isolation violation"
  • "Antivirus software ... access to the BLOB data in the affected file will be prevented, and to SQL Server the file will appear to have been deleted."
  • "Note that for a table to have one or more FILESTREAM columns, it must also have a column of the uniqueidentifier data type that has the ROWGUIDCOL attribute. This column must not allow null values and must have either a UNIQUE or PRIMARY KEY single-column constraint"
  • "anything that can prevent transaction log truncation may also prevent a FILESTREAM file being physically deleted. Some examples are:"
  • FILESTREAM data containers cannot be nested


I cannot coach you online. This is Q&A board. I already had been banned many times for infringing the rules on StackExchange having discussions instead of posting question or answer


DBCC CheckDB (QPS8, repair_rebuild)


and put output here.

To check/set NTFS permissions: right-click on folder in Windows --> Properties --> Security

To check/set MSSQLServer: in command line type


navigate to SQL Server Services and double-click corresponding instance of SQL Server

Update 3b:
Probably, you should drop and recreate index or you have further deeper issues and you should restore database from backup or perform database repair permitting loss of data. This is quite separate topic/question.
I do not want to take any responsibility to guide you on it.

  • I'm not deleting rows, I'm setting the Filestream column to null, as per technet.microsoft.com/en-us/library/bb933993.aspx
    – cofiem
    Dec 8, 2010 at 10:22
  • DBCC CHECKDB found an error, see question. Thanks very much for your help so far. Any ideas on the error?
    – cofiem
    Dec 8, 2010 at 23:29
  • thanks for your help - I haven't been able to resolve this, but you helped me find out what was wrong, so I'll accept this as the answer.
    – cofiem
    Dec 12, 2010 at 8:59
  • 1
    Good answer. Shouldn't be CW though
    – gbn
    Jan 21, 2012 at 18:50

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.