Tuesday, 20 December 2011

SQL Server Restore - Filestream feature is disabled

I was trying to restore a database in SQL Server 2008 and got the error: Restore failed... FILESTREAM feature is disabled.  It was annoying because I was able to restore another database no problem, but this particular one I couldn't restore.

After much Googling, I figured out how to enable the file stream.  There are two steps:
  1. Open SQL Configuration Manager, click on SQL Server Services on the left hand pane, and then right-click SQL Server on the right hand pane.  Select properties.  On the FILESTREAM tab, check off all three options.  OK out of the dialog and restart SQL Server. (Right-click and select restart).
  2. Run the following in SQL Management Studio:
EXEC sp_configure filestream_access_level, 2
RECONFIGURE
After that, I was able to restore the database.
Posted by at
Labels: ,

4 comments:

  1. Unknown21 September 2015 at 00:31


    Life is a battle, if you don't know how to defend yourself then you'll end up being a loser. So, better take any challenges as your stepping stone to become a better person. Have fun, explore and make a lot of memories.

    n8fan.net

    www.n8fan.net

    ReplyDelete
  2. Eduardo Álvarez16 May 2016 at 09:19

    Excellent! A lifesaver post. Thanks David.

    ReplyDelete
  3. Unknown3 August 2016 at 22:59

    FINALLY able to restore a backup. Thanks!

    ReplyDelete
  4. Unknown8 December 2016 at 09:01

    Thanks. Helped me out.

    ReplyDelete

Subscribe to: Post Comments (Atom)