Restoring SQL Server databases in Powershell

RestoreSqlDb.ps1

$dbName = "MyDatabase"
$serverAddress = ".\SqlServer"

# Delete the existing database.
$server = new-Object Microsoft.SqlServer.Management.Smo.Server($serverAddress)
if($server.Databases[$dbName)
{
    $server.KillDatabase($dbName)
}

# Prepare new locations for the database files to live.
$RelocateData = `
    New-Object 'Microsoft.SqlServer.Management.Smo.RelocateFile, Microsoft.SqlServer.SmoExtended, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' `
    -ArgumentList $dbName,"path\to\data\$dbName.mdf"
$RelocateLog = `
    New-Object 'Microsoft.SqlServer.Management.Smo.RelocateFile, Microsoft.SqlServer.SmoExtended, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' `
    -ArgumentList "$dbName_log","path\to\data\$dbName.ldf"

Restore-SqlDatabase `
    -ServerInstance $serverAddress`
    -Database $dbName `
    -BackupFile "Path\to\backup.bak" `
    -RestoreAction Database `
    -RelocateFile @($RelocateData,$RelocateLog)