none
Adding New Mounted Volume for SQL Server 2008 R2 on a Windows 2008 R2 Cluster RRS feed

  • Question

  • We have a 2-node classic active passive SQL Server cluster.... both DB and O/S are 2008 R2

    There is an existing F:\ and H:\ drives for SQL Server to use and everything is fine - for many years

    We needed to add a new volume\drive to the cluster as K:\ drive... using the same practices and config settings as H:\

    Everything is fine at the O/S level, but SQL Server cannot see the new K:\ drive as a mounted volume, therefore does not want to access to the new drive.

    Question: with 2008 R2  ... were we used to failover/restart SQL Server back then?

    If not, what can be the most common cause for this issue.

    Thank you so much for your kind help.

    Monday, June 26, 2017 8:52 PM

All replies

  • Hi,

    Have you added the new mounted drive to Windows Cluster.

    https://support.microsoft.com/en-in/help/947021/how-to-configure-volume-mount-points-on-a-server-cluster-in-windows-server-2008,-windows-server-2008-r2,-windows-server-2012,-and-windows-server-2012-r2

    https://mssqltrek.com/2012/06/28/how-to-add-a-new-diskdrive-to-sql-server-failover-cluster/

    Thanks,


    Thanks, Satish Kumar. Please mark as this post as answered if my anser helps you to resolves your issue :)

    Monday, June 26, 2017 8:58 PM