SQL Server clustered instance dependencies – verification


To check and verify if the existent dependencies for sql server resources are in place

My way of achieving it

Using powershell. From time to time due to adding more disks to an instance or performing other activities we end up having a resource that is not tied to the parent resource and when it comes to sql server disks some of the databases residing on those disks are not accessible. In order to check if we have any of the resources not being tied to the right parent resource I have created the script below that will tell us which resources are not tied. The output of the script looks like below


The code can be downloaded fromĀ here