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