FAQ: What do I do when I get the message: “Cannot restore database as filestream is disabled”?

By Julie Rodney

Q: Why do I receive the following message when trying to restore a SQL database Backup in SQL Management Studio: “Cannot restore database as filestream is disabled”

A: In order to restore the database please do the following:
1. Open SQL Configuration Manager
2. Select the SQL Server service
3. Right click on SQL Server service and click Properties
4. On the Filestream tab, click the tick box, enable filestream
5. Click apply then OK
6. Now you will be able to restore the database backup