To obtain disk information like number, size, partition style, drive label and drive letter
My way of achieving it
Using powershell. I must start by saying that this requires windows 2012. The necessity of having something like this is my desire to create a SQL installation script that eventually will install a SQL Server from one end to the other. The only parameters that the script will require will be the account used for the services and the instance name. Everything else will be discovered automatically. The script from this post is my attempt of discovering the disks available on a server and formatting them accordingly. Till now the script was tested only against simple volumes. The script contains a few functions, one that discover all the disks, another one that discover all available disks (RAW format) , another one that prepare the disk for a stand alone installation of SQL Server and the last one which is preparing the disk for a clustered SQL server installation.
Below is the output generated by the script.
As in the case of any actions that change the data, the format functions should be used with caution. The steps for running the script in a safe manner will be to execute the script and call the functions in the following order
- formatclusterdisk or formatclusterdisk with the whatif parameter
- formatclusterdisk or formatclusterdisk without the whatif only after checking that indeed the disk is RAW.
The script can be downloaded from here