How to fix Filestream enabled database

• amersaw

  Valued Member

  Points: 67

  More actions

  April 21, 2013 at 12:26 pm

  #292422

  I have SQL Server 2008 R2 FileStream enabled Database, when I try to access any value that stored in the filestream I get the following error :

  Msg 233, Level 20, State 0, Line 0

  A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

  I read about that exception and Microsoft has KB for it (KB972936), but it also didn't worked after I installed its hotfix.

  If I SELECT the count of the records in that table using :

  SELECT COUNT(1) FROM [Table_Name]

  I get a correct result.

  Here is some details for the database files and filegroups :

  The database have 2 files the "Row Data" file and the "Log" file where it should also contains the "Filestream Data" item.

  The database has the following filegroups :

  - Rows : PRIMARY with 1 File

  - Filestream : [MyFileName] with 0 Files !

  Here is a snapshots for the DB properties page (LINK)

  And here is the full SQL ERRORLOG file (LINK).