How can i get the servers that have SharePoint configuration database in my farm?

Question

I have a SharePoint 2016 farm, this farm has multiple database servers and I want to get the database server that my configuration database hosted on it using PowerShell.

Which Database Servers hold the SharePoint configuration database on my farm using PowerShell??

Answer 1

Which Database Servers hold the SharePoint configuration database on my farm?

You have two options to get the SharePoint Configuration Database Server

1. Using PowerShell.
2. Using Central Administration.

Get the SharePoint Configuration Database Server using PowerShell

(Get-SPDatabase | ?{$_.Type -eq “Configuration Database”}).server

Get the SharePoint Configuration Database Server using Central Administration

In "Manage Servers In this farm", Check "Configuration Database Server"

For more details, Please Check Get SharePoint Config Database Server via PowerShell and Get SharePoint Farm Build Version

Comments

thanks brother for these helpful details ,appreciated