Quickly create folders for database on empty drives
From DevOps Notebook
For powershell
foreach ($drive in 'A','D','R') {
foreach ($folder in 'Data','Log') {
New-Item -ItemType Directory -Force -Path "$drive`:\MSSQL\$folder"
}
}
For CMD
for %%d in (A D R) do (
mkdir %%d:\MSSQL\Data
mkdir %%d:\MSSQL\Log
)