Powershell Script

Closed Posted 6 years ago Paid on delivery
Closed Paid on delivery

In WFC a shared disk device has a dependency on a cluster resource like SQL Server. With the introduction of CSV (Cluster Shared Volumes) this dependency isn’t there any longer because we assume that a CSV is always there. That’s right (sometimes), but if a SAN failure happens, the CSV or several volumes presenting the CSV will be gone and SQL Server will start again. Ths brings SQL Server in an unpredictable situation and happened.

So we like to have a PowerShell-Script (running on every node on the cluster) monitoring the CSV and stopping the group hosting the SQL resources if CSV failures happen.

CSVMonitor is a prototype.

Microsoft SQL Server Powershell Shell Script Software Architecture SQL

Project ID: #16493099

About the project

Remote project Active 5 years ago