bounce-db.ps1 - stops sql server services and deletes the mdf/ldf

bounce-db.ps1

Import-Module SQLPS

 

$server = New-Object Microsoft.SqlServer.Management.Smo.Server("localhost")
$db = $server.databases["YOURDBNAME"]
if ($db) {
    $server.KillAllprocesses("YOURDBNAME")
    $db.Drop()    
}

 

net stop mssqlserver
net stop sqltelemetry
net stop sqlwriter

 

cd "C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Data"
del Blss*.*f

 

net start mssqlserver
net start sqltelemetry
net start sqlwriter
dir *.*df