How to Set Up SQL Server 2008 FileStream In the Cluster

最新推荐文章于 2019-07-31 09:54:24 发布

灰太狼

最新推荐文章于 2019-07-31 09:54:24 发布

阅读量1.4k

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/tjvictor/article/details/5107040

Sql Server 2008 专栏收录该内容

54 篇文章

订阅专栏

本文解决了一个关于 SQL Server 2008 的 FileStream 功能在集群环境中遇到的问题。当 SQL 实例从一个节点移动到另一个节点时，Filestream 数据库会失效。发现必须在集群中的每个节点上启用 FileStream 选项才能解决问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Today i meet a very odd problem. i use sql server 2008 filestream in the cluster, when i remove a sql instance form one node to another, the operator is succecced, but the filestream db is disable. when i remove the instance to original node, the filestream db can work. Why?

Finally, I find that you must enable the filestream option in every node of your cluster. For example, if you have three nodes in your cluster, you must choose all the “enable filestream” options from “Sql Server Configuration Manager” in every node.

That is so trouble, right? Fortunately, if you choose “enable filestream” option when you install the sql server instance, then you will not meet this problem. Because the setup program will do the same thing for you.

如需转载，请注明本文原创自优快云 TJVictor专栏：http://blog.youkuaiyun.com/tjvictor