#PSTip List SQL database mirroring partner using SMO

Note: This tip requires PowerShell 2.0 or above.

In an earlier tip, we looked at how to verify if a SQL database is mirrored. Continuing this series on SQL SMO tips series, let us look at how we can list the SQL database mirroring partner information. I find this information quite helpful when managing the SQL Server mirroring. The database class in SQL SMO has a property called MirroringPartner. This provides us the information of the Database Engine instance that is the partner server for database mirroring.

Add-Type -AssemblyName "Microsoft.SqlServer.Smo, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"
$smo = New-Object Microsoft.SqlServer.Management.Smo.Server $env:COMPUTERNAME
$smo.Databases['MyDB'].MirroringPartner

The above code snippet returns the mirroring partner FQDN along with the TCP port number. In case you need only the name of the SQL Server instance hosting the mirroring partner, you can use the following code.

$smo.Databases['MyDB'].MirroringPartnerInstance

About the author: Ravikanth C

Ravikanth is the founder and editor of the PowerShell Magazine. He is also a PowerShell MVP who works at Dell Inc. He blogs at http://www.ravichaganti.com/blog and you can follow him on Twitter @ravikanth.

Related Posts

%d bloggers like this: