Demo - PowerShell + DevOps Global Summit 2019 - Parallel Restores

Parallel_Restores.ps1

# Restoring Databases from Files in Parallel

# Let's restore 11, 21, 41 databases!
     $DbSuffixRange = 500..510
    # $DbSuffixRange = 500..520
    # $DbSuffixRange = 500..540

$RSJobparamHash = @{
    Throttle        = 8
    ModulesToImport = "dbatools"
    InputObject     = $DbSuffixRange
    Verbose         = $True
}

Start-RSJob @RSJobparamHash -ScriptBlock {
    # How will the backup headers be scanned?  SQL Server and Backup Path
    $BkParamHash = @{
        SqlInstance = "localhost"
        Path        = "D:\Share01\Demo", "D:\Share02\Demo"
    }

    $BackupMetaData = Get-DbaBackupInformation @BkParamHash -Verbose

    $DbSuffix = $_

    #$DbSuffix = [string]$DbSuffix
    Write-Output "$DbSuffix ***" | Out-String | Write-Host -ForegroundColor Cyan
    
    $FileMapping = @{
        'pubs'     = "C:\SQLDataFiles\pubs_$DbSuffix.mdf"
        'pubs_Log' = "C:\SQLLogFiles\pubs_log$DbSuffix.ldf" 
    }

    $RestoreParamHash = @{
        sqlinstance  = "localhost"
        DatabaseName = "pubs_$DbSuffix"
        FileMapping  = $FileMapping
        #TrustDbBackupHistory = $True
    }

    $BackupMetaData | Restore-DbaDatabase @RestoreparamHash -Verbose `
    | Wait-RSJob -ShowProgress -Verbose | Receive-RSJob -Verbose;
}