SQL Server - Enabling FileStream after a DB has be

Question

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?

Answer 1

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;
go

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

More here: BOL Link

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

Answer 2

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.

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

Then you need to run

EXEC sp_configure filestream_access_level, 2

RECONFIGURE