Large object (LOB) data for table

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Large object (LOB) data for table

Large object (LOB) data for table

Rate Topic

Display Mode

Topic Options

Author

Message

michaelmfranz

Posted Wednesday, November 14, 2012 12:01 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, February 20, 2013 5:47 AM
Points: 3, Visits: 43

I have an existing table for LOB data(it is used in production) that others in my org say cannot be used (needs to be restored), how do i enable it for the dev environment? I have tried all the scripts and configs I have found on the net like

EXEC sp_configure filestream_access_level, 2
RECONFIGURE

and also configuration through management studio (all looks good)

this is the error message i receive when i do a select * on the table

Msg 670, Level 16, State 1, Line 2
Large object (LOB) data for table "dbo.FS_Blob" resides on an offline filegroup ("SC_ProductionFS") that cannot be accessed.

Post #1384410

Stewart "Arturius" Campbell

Posted Wednesday, November 14, 2012 1:38 AM

Hall of Fame

Group: General Forum Members
Last Login: Thursday, June 13, 2013 9:46 AM
Points: 3,157, Visits: 4,341

The issue appears to be that the offending filegroup is set to offline.
You will need to restore it from a backup to set online (Refer ALTER DATABASE File and Filegroup Options (Transact-SQL).
For more information about restoring a single file, see RESTORE (Transact-SQL).

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

Post #1384454

« Prev Topic | Next Topic »

Permissions