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