Post reply

Does Mount points on a cluster support FileStream?

  • January 19, 2012 at 10:27 am

    #249849

    Hi,

    We have 2 node cluster with Drive letters with FileStream feature enabled.

    Now, we want to install another instance in the same cluster but we are facing the drive letter limitation.

    Questions:

    1. Can we migrate the exiting databases to Mountpoints by creating a mount point and multiple folders inside and then restore the databases moving the mdf & ldf files to new mount point folders and then later delete the drives?

    What is the process to achieve this?

    2. Does Mount points on a cluster support FileStream?

    Is there any good book which explains the cluster set up on Mount Points in detail?

    Thanks

  • January 19, 2012 at 11:33 am

    #1436095

    I just found the below link, which confirms the SQL Server 2008 does NOT support MountPoints with FileStream.

    http://connect.microsoft.com/SQLServer/feedback/details/324820/sql-server-2008-filestream-support-for-mount-points

    Is it still DOES NOT support in SQL Server 2008 R2 too?

    Please advice

  • March 6, 2012 at 2:31 pm

    #1455596

    Still I'm not sure whether SQL Server 2008 R2 Filestream supports for Mount Points in cluster environment?

    Please clarify me...

    Thanks

  • March 6, 2012 at 3:41 pm

    #1455646

    This suggests it is supported 😉

    Are your shared disks Veritas SFW disks?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • March 6, 2012 at 9:08 pm

    #1455719

    We are NOT using Veritas SFW disks.

    We have EMC SAN.

    Thanks

  • March 7, 2012 at 5:10 pm

    #1456324

    Does Mount points on a cluster support FileStream? I did not find this information in BOL

    I need this information to get start with a new project. Please advice..

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply