Large object (LOB) data for table

• michaelmfranz

  SSC Veteran

  Points: 263

  More actions

  November 14, 2012 at 12:01 am

  #270895

  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.

• November 14, 2012 at 1:38 am

  This was removed by the editor as SPAM