Get SharePoint Config Database Server via PowerShell

In this hint. I will show How to

Get the database server that host SharePoint configuration database using PowerShell

Steps

Get SharePoint Config Database Server Using PowerShell

  • Open SharePoint Management Shell as Administrator.

Run SharePoint Management Shell as Administrator - Devoworx

  • Run the following cmdlet.

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

Get-SPConfigDatabase in SharePoint


Get-SPDatabase Cmdlet In SharePoint Explanation

  • Get all SharePoint database via Get-SPDatabase.
  • Select only Name and Type.
  • Filter database with its type then gets its server.

Get-SPDatabase in SharePoint


Get SharePoint Config Database Server Using Central Administration

  • Open Central Administration > Below System Settings > Click on Manage Servers In this farm.System Settings in SharePoint
  • Below Farm Information > Check Configuration Database Server.

Servers in Farm In SharePoint - Get Configuration Database Server


Applies To
  • SharePoint 2016.
  • SharePoint 2013.
  • SharePoint 2010.
Conclusion

In this hint, I have explained Which database server that hosts the SharePoint Configuration Database?

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s