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{ } }