After much Googling, I figured out how to enable the file stream. There are two steps:
- 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).
- Run the following in SQL Management Studio:
After that, I was able to restore the database.EXEC sp_configure filestream_access_level, 2RECONFIGURE
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
Excellent! A lifesaver post. Thanks David.
ReplyDeleteFINALLY able to restore a backup. Thanks!
ReplyDeleteThanks. Helped me out.
ReplyDelete