SQL Server – Enabling FileStream after a DB has been created

We have a database and have decided to enable it for FileStream use. I think I’ve done everything I’m supposed to except creating a FileStream Data Container. I can’t seem to find a way to do this in SSMS 2008 on our existing database. Can this only be done at the time a database is created?

  • Rows to columns SQL Server query
  • How do I run a script using a BAT file?
  • I need help using CAST to return the month/day only
  • How to return a field from MSSQL based on the value of two other fields
  • How can I change from SQL Server Windows mode to mixed mode (SQL Server 2008)?
  • Extracting UID from ODBC Connection in MS Access
  • 2 Solutions collect form web for “SQL Server – Enabling FileStream after a DB has been created”

    To add FS support to existing database just create a new filegroup, then add the fs file;

    alter database YourDatabase
    add filegroup fsGroup contains filestream;
    alter database YourDatabase
    add file
      ( NAME = 'fsYourDatabase', FILENAME = 'c:\<your_file_path>'
    to filegroup fsGroup;

    More here: BOL Link

    And definitely read everything Paul Randal has written about filestream: link

    From http://brianseekford.com/wordpress/?p=509

    If you still get FILESTREAM feature is disabled. check the ‘running values’ of your server and you’ll probably still see it is disabled even if you enabled it.

    enter image description here

    You can fix it by enabling filestream here too (under Sql configuration manager).

    enter image description here

    Then you need to run

    EXEC sp_configure filestream_access_level, 2


    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.