PowerShell – Checking Status of MSSQL Server Mirrored DB’s
// September 26th, 2012 // Comments Off on PowerShell – Checking Status of MSSQL Server Mirrored DB’s // Infrastructure
# Load SMO extension [System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo") | Out-Null; # Servers to check $sqlservers = @("server1", "server2", "server3"); foreach($server in $sqlservers) { $srv = New-Object "Microsoft.SqlServer.Management.Smo.Server" $server; # Get mirrored databases $databases = $srv.Databases | Where-Object {$_.IsMirroringEnabled -eq $true}; Write-Host $server; Write-Host "=================================="; $databases | Select-Object -Property Name, MirroringStatus | Format-Table -AutoSize; }