Restore SQL User Databases Using PowerShell

restoreUserDatabases.ps1

Import-Module SQLPS -DisableNameChecking -EA 0
$backupPath = "J:\Backups" # location of all the .bak files
$sqlInstance = $env:COMPUTERNAME
$files = Get-ChildItem -Path $backupPath -Filter *.bak
foreach ($file in $files) {
	$fileName = $file.Name
	$dbName = $fileName.Substring(0,($fileName.Length - 13)) # length based off suffix of "_yyyyMMdd.bak"  eg: "_20161901.bak"
    Write-Verbose ("Restoring $dbName...") -Verbose
    Restore-SqlDatabase -ServerInstance $sqlInstance -Database $dbName -BackupFile $file.FullName -RestoreAction Database -ReplaceDatabase
}