Making Mounted disks available for SQL on a cluster
-
OS Windows Server 2012
SQL 2012
I have a software that presents a drive to a 2 node cluster.
Not sure how I would go about presenting this newly presented drive as a Cluster Resource and make SQL depend on this resource.
Not even sure where to begin, any help is welcome.
P.S. I am not a PowerShell Guy.
Paresh Motiwala Manager of Data Team, Big Data Enthusiast, ex DBA
-
Hi Perry, this is very elaborate. Thanks for sharing.
But I was looking for a PowerShell based solution.
P.S. this is not an AO AG.
Cheers
Paresh
Paresh Motiwala Manager of Data Team, Big Data Enthusiast, ex DBA
-
Paresh Motiwala (5/13/2015)
But I was looking for a PowerShell based solution.You're not a powershell expert so why would you want complicated, involved scripts to do this instead of the GUI???
Paresh Motiwala (5/13/2015)
P.S. this is not an AO AG.Cheers
Paresh
It doesn't matter, the process of setting up the volumes is the same hence my comment below
Perry WhittleThis should be of some help, in parts
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs"
-
I have to write a script so this process is automated for a customer.
I dabble in PS but not that deeply hence the question.
Hope this helps
Paresh
Paresh Motiwala Manager of Data Team, Big Data Enthusiast, ex DBA
-
I got this to work:
get-clusteravailabledisk | Add-ClusterDisk
Add-ClusterSharedVolume -Name "Cluster Disk 4"
Start-ClusterResource "Cluster Disk 4"
Move-ClusterResource -name "cluster disk 4" -Group "SQL Server (MSSQLSERVER)"
Paresh Motiwala Manager of Data Team, Big Data Enthusiast, ex DBA
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply