How to restore a busy database from Powershell?

Question

PowerShell

I want to restore the database from a backup, everything works if no one is connected to it. If there are connections to it, then it says: "Exclusive access could not be obtained because the database is in use." How to cut off connections from powershell?

Restore-SqlDatabase -ServerInstance 'srv-sql7' -Database 'Billing'  -ReplaceDatabase -BackupFile $billingBackup.FullName;

Answer 1

$ServerName = 'srv-sql7'
$DBName = 'Billing'

$Server = New-Object -TypeName Microsoft.SqlServer.Management.Smo.Server -ArgumentList $ServerName
$Server.KillAllProcesses($DBName)