Quick script to spit out the backup directories for your sql servers.
Import-Module SqlPS -DisableNameChecking
$objects = @();
try{
gc -Path c:\Servers.txt | %{
$srv = new-object Microsoft.SqlServer.Management.Smo.Server $_
$objects += [PSCustomObject]@{
ServerName = $srv.Name
BackupDir = $srv.BackupDirectory
}
}
$objects | Out-GridView
}
catch{
$_ | fl -Force
}
Leave a comment