Quickly create folders for database on empty drives

From DevOps Notebook
Revision as of 15:25, 28 February 2026 by MilosZ (talk | contribs) (Created page with "For powershell <br> <pre> foreach ($drive in 'A','D','R') { foreach ($folder in 'Data','Log') { New-Item -ItemType Directory -Force -Path "$drive`:\MSSQL\$folder"...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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
)