sql-server-emergency-maintenance

sql-server-emergency-maintenance.ps1

Import-Module SQLPS -DisableNameChecking

#replace this with your instance name
$instanceName = "server\instance";
$srv = New-Object -TypeName Microsoft.SqlServer.Management.Smo.Server -ArgumentList $instanceName;

$dbName = "DatabaseName"

$db = $srv.Databases.Item($dbName)
# Stops the all processes on the specified database.
$server.KillAllprocesses($dbName);

# Alter the files in SQL server (new path and/or name)
$db.FileGroups["NameFileGroup"].Files['LogicalName'].FileName = 'path\filename'

# Cannot move data files while online
$db.SetOffline();
$db.Alter();

# Move 
Move-Item 'path\filename' 'path'

# And back online again
$db.SetOnline();
$db.Alter();