Do we need to create FILESTREAM TABLES?

• gary1

  SSC-Insane

  Points: 21152

  More actions

  August 16, 2011 at 4:56 pm

  #241783

  Hi,

  We are implementing FILESTREAM for RBS in SQL Server 2008 R2 for Share point content databases.

  Steps Performed:

  Step 1:

  enabled FILESTREAM option Using SQL Server Configuration

  Step 2:

  sp_configure filestream_access_level,2

  reconfigure

  go

  Step3:

  Use WSS_Content_DB1

  go

  if not exists (select groupname from sysfilegroups where groupname=N'RBSFilestreamProvider')

  Alter database WSS_Content_DB1

  add filegroup RBSFilestreamProvider contains filestream

  Step4:

  Alter database WSS_Content_DB1

  add file (name = RBSFilestreamFile, filename = 'E:\Blobstore') to filegroup RBSFilestreamProvider

  Question:

  After completing above 4 steps, do we MUST need to create FILESTREAM TABLES in the above database?

  Thanks

• August 17, 2011 at 1:30 am

  This was removed by the editor as SPAM

• Grant Fritchey

  SSC Guru

  Points: 398886

  More actions

  August 17, 2011 at 5:37 am

  #1369513

  If you don't create tables with FILESTREAM, why set it up on the database at all?

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning