In all information i searched, I see two conflicting statements:
1) If you are on a FAILOVER CLULSTERING environment place the FILESTREAM file groups in a shared disk.
2) FILESTREAM data can be stored only on local disk volumes.
Can someone explain which of these is correct. I intend to use filestream in a clustered environment. In case of a failover, I want the data stored to be accessible from the partner database. Therefore I believe I must store the data on a shared disk. But as per above statements if it can be stored only on a local disk, how can the data be made available in a failover clustering environment?