Edit Multi Subnet Failover database property for SharePoint databases

Categories: PowerShell, SharePoint, SQL Server
#Use SharePoint 2013 Management Shell
#Enable Multi Subnet Failover in all databases
#Enable connections to SharePoint availability groups (listener - AlwaysOn)
#Script PowerShell
$dbs = Get-SPDatabase | ?{$_.MultiSubnetFailover –ne $true}
     foreach ($db in $dbs)
     {
          $db.MultiSubnetFailover = $true
           $db.Update()
     }
«
»

    Leave a Reply

    Your email address will not be published. Required fields are marked *

    This site uses Akismet to reduce spam. Learn how your comment data is processed.