Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to fix Filestream enabled database Expand / Collapse
Author
Message
Posted Sunday, April 21, 2013 12:26 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 3, 2013 8:12 AM
Points: 1, Visits: 6
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).
Post #1444812
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse