Demo - PowerShell + DevOps Global Summit 2019 - Sequential Restores

Sequential_Restores.ps1

# 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

# Let's restore 11 databases
$DbSuffixRange = 500..510
ForEach ($DbSuffix in $DbSuffixRange) {

    #$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
}


<#
-FileMapping <Hashtable>
        A hashtable that can be used to move specific files to a location.
        $FileMapping = @{'DataFile1'='c:\restoredfiles\Datafile1.mdf';'DataFile3'='d:\DataFile3.mdf'}
        And files not specified in the mapping will be restored to their original location
        This Parameter is exclusive with DestinationDataDirectory

#>