Skript pro obnovu databaze z backupu

restore-db.ps1

$bak_folder = "c:\backups\db"

$sql_server_user = "sa"
$sql_server_pwd = "P4$$w0rd"

$databases = @{ "DbName"="db.bak" }

function Restore-Backups {
    
    foreach ($db in $databases.keys) {
        osql -U $sql_server_user -P $sql_server_pwd -Q "RESTORE DATABASE $db FROM disk= '$bak_folder\$($databases[$db])' WITH REPLACE;USE [$db]; ALTER USER [$db] WITH LOGIN = [$db];"
    }
    
}