SQL Server Performance

Disabling Filestream

Discussion in 'Getting Started' started by rinuv, Aug 16, 2010.

  1. rinuv New Member


    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.

  2. satya Moderator

Share This Page