How to Set Up SQL Server 2008 FileStream In the Cluster

最新推荐文章于 2025-12-01 23:29:26 发布

最新推荐文章于 2025-12-01 23:29:26 发布 · 105 阅读

文章标签：

#SQL Server #UP #SQL #.net #Blog

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

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