FileStream Shared Disk as Dependency on sql server service in Cluster environment

• gary1

  SSC-Insane

  Points: 21152

  More actions

  August 29, 2011 at 3:36 pm

  #242964

  Hi,

  We are implementing Filestream in SQL Server 2008 R2 on a/p cluster.

  Do we need to add FILESTREAM shared disk as a sql server service dependency in Failover cluster management?

  Thanks

• okbangas

  SSChampion

  Points: 11773

  More actions

  August 30, 2011 at 2:59 am

  #1374849

  Yes, the SQL Server Instance must depend on the disk for you filestream data.

  ---

  
  Ole Kristian Velstadbråten Bangås - Virinco - Facebook - Twitter

  Concatenating Row Values in Transact-SQL[/url]

• Satya(SQLMaster)

  SSC Eights!

  Points: 872

  More actions

  September 1, 2011 at 2:38 am

  #1375834

  See what BOL refered: For failover clustering, FILESTREAM filegroups must be put on a shared disk. FILESTREAM must be enabled on each node in the cluster that will host the FILESTREAM instance. For more information, see How to: Set Up FILESTREAM on a Failover Cluster- http://msdn.microsoft.com/en-us/library/cc645886.aspx

  -Satya SK Jayanty
  SQL Server MVP (Follow me @sqlmaster)
  Author of SQL Server 2008 R2 Administration CookBook
  SQL Server Knowledge Sharing network