Quick script on how to set a sql servers’ default backup directory via powershell. Use at your own risk.
#requires -module SqlPS
#requires -version 4
function Set-SqlDefaultBackupDirectory{
[cmdletbinding(SupportsShouldProcess=$true)]
param(
[string]$ComputerName,
[string]$BackupDirectory
)
begin{
Import-Module SqlPS -DisableNameChecking
}
process{
try{
if($PSCmdlet.ShouldProcess($ComputerName)){
$srv = New-Object Microsoft.SqlServer.Management.Smo.Server $ComputerName
$srv.BackupDirectory = $BackupDirectory
$srv.Alter();
}
else{
Write-Host "Setting the default backup directory on server $ComputerName to $BackupDirectory"
}
}
catch{
throw $_
}
}
end{
}
}
Leave a comment