Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 How can I drop a offline filestream?
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

5 Posts

Posted - 03/13/2014 :  08:48:09  Show Profile  Reply with Quote

I have a database that missing the filestream data because the filestream folder was deleted. The data of the filestream is not important. So I don't need repair.

But now I can't use the Table that using the filestream. Always I get:

Meldung 670, Ebene 16, Status 1, Zeile 1
LOB-Daten (Large Object) für die dbo.Test-Tabelle befinden sich in einer Offlinedateigruppe ('TestFG') auf die kein Zugriff möglich ist.

I tried to drop the column but I got the message that the filegroup is offline.

Then I tried to drop the filestream from the db and got following message

Der Systemprotokoll-Datensatz '$RECYCLE.BIN' der FILESTREAM-Datei unter dem Protokollordner '' ist beschädigt. (Microsoft SQL Server, Fehler: 5511)

The state of the filestream is RECOVERY_PENDING

FROM sys.database_files 
WHERE type = 2

To get the same issue you need a db with Filestream enabled and with filestream data in a table. Then make a backup without filestream:

TO DISK = 'C:\fsdb.bak' WITH INIT

Then restore it

from DISK = N'c:\fsdb.bak' 

RESTORE Database test2
Filegroup = 'PRIMARY'
from DISK = N'C:\fsdb.bak' 
WITH MOVE 'FSDB' TO 'c:\fsdb.mdf',
MOVE 'FSDB_log' TO 'c:\fsdb.ldf'

I only want to remove or replace the filestream or filegroup so that I can make an "SELECT * FROM test" without error.

Please, can someone help me?

Regards, Lars
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000