Hello, We have a new sharepoint 2010 farm setup and we were playing with fliestream. We decided not to use it and I disabled filestream. After restarting the sql service, the database went off-line and I got the following message: Database '<db_name>' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details. I looked at the log file and saw the following: FILESTREAM feature is disabled. Error: 5105, Severity: 16, State: 14. A file activation error occurred. The physical file name '<path>be incorrect. Diagnose and correct additional errors, and retry the operation. How do I get around this issue? How do I disable filestream without making the database inaccessible? Thanks in advance for any input.
The new Sharepoint 2010 version requires the FILESTREAM to be enabled for remote blob storage, see from one of the MSDN blogs: http://blogs.msdn.com/b/opal/archive/2010/03/24/faq-sharepoint-2010-remote-blob-storage-rbs.aspx faq. Also see this http://bkemmler.blogspot.com/2010/03/enable-filestream-rbs-for-sharepoint.html from Brend to accomplish the solution. If you want to use the SP2010 features then you must keep the FILESTREAM and using better techniques of Security you can continue.
