Can we enable file streaming capability in Sql server 2008R2 clustered instance?

Hi,

We are having a Sql Clustered instance of SqlServer 2008 R2 running
on windows server 2008 R2 with 2 nodes. We have about 88 databases in the instance.
Our servers run on Intel Xeon(R) CPU X5670 @2.94 GHz with 6 cores(12 logical processor).
The servers are having 12GB of RAM.Our network storage is in EMC and for data we are having
a shared voume of 2 TB for the data(for both mdf and ldf files). I would like to know
whether there would be any problem in enabling file streaming through GUI in the clustered
instance. I understand that by creating a table with a file stream coloumn would create a
subfolder in the file stream data container. Once we created a shared folder in the shared
volume(lun) and there was a server reboot in the active node. Should be anticipate any such eventuality.
Are the steps of enabling file stream capability in the clustered instance same as that of enabling it
in a noram instance?

Thanking you in anticipation,

Binny Mathew

March 29th, 2015 5:16am

IRW,If you are using FILESTREAM on a clustering environment, FILESTREAM file groups must be on shared disk resources

Free Windows Admin Tool Kit Click here and download it now
March 29th, 2015 7:12am

Hi Binny,

It is supported to enable FILESTREAM on SQL Server Failover Cluster using SQL Server Configuration Manager. During the process of either setting up SQL Server Failover Cluster or enabling FILESTREAM on SQL Server Failover Cluster, if you are prompted to restart your computer, please restart. The steps of enabling FILESTREAM on SQL Server Failover Cluster is the same with enabling FILESTREAM in a Non-Cluster Environment. For how to enable FILESTREAM on SQL Server Failover Cluster, please refer to the following steps:

1. After the setup of the primary node for the failover cluster finishes, enable FILESTREAM on the primary node by using SQL Server Configuration Manager. This enables the settings that require Windows Admin privileges. If remote access is required, select Allow remote clients to have streaming access to FILESTREAM data. This will create a file-share cluster resource.

2. After the setup of a passive node finishes, enable FILESTREAM on the passive node by using SQL Server Configuration Manager. The name that you specify for Windows Share Name must be the same across all nodes in the cluster.

3.To add more passive nodes, repeat step 2.

4.After all the nodes are added, complete the process by executing the sp_configure stored procedure on each instance of SQL Server.

5.To add and enable additional nodes to the cluster at any time, you can repeat steps 2, 3, and 4.

For more information about the process, please refer to the article: https://msdn.microsoft.com/en-us/library/cc645886(v=sql.105).aspx

Regards,
Michelle Li

March 30th, 2015 3:38am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics