How to know which content database a site collection is using in SharePoint 2016 or SharePoint 2013?

How to know which content database a site collection is using in SharePoint 2016 or SharePoint 2019?
InfoPath alternatives for form designing SharePoint

Here we will discuss how we can easily know which content database one site collection is using in SharePoint 2016 or SharePoint 2013. We can see how we can know this by out of box way and also we can see how we can know using PowerShell.

Out of box approach:
We can get to know from the central administration. Open SharePoint 2016 central administration. Then click on Application Management.

Then under Site Collections, click on View all site collections.

In this page you can see the particular site collection and then in the right side you can see the content database name like below:

 How to know which content database a site collection is using in SharePoint 2016 or SharePoint 2013?
How to know which content database a site collection is using in SharePoint 2016 or SharePoint 2013?

Also read: How to get content database size using PowerShell in SharePoint 2016 and using SharePoint server object model

Using PowerShell:
Using PowerShell also we can be able to know which content database one site collection is using.

Add-PSSnapin Microsoft.SharePoint.PowerShell -EA SilentlyContinue

(Get-SPSite “http://mypc:29024/sites/HydTraining/”).ContentDatabase.name

 How to know which content database a site collection is using in SharePoint 2016 or SharePoint 2019?
How to know which content database a site collection is using in SharePoint 2016 or SharePoint 2019?

Hope this will be helpful.

Similar SharePoint 2013 Tutorials

About Bijay Kumar

I am Bijay from Odisha, India. Currently working in my own venture TSInfo Technologies in Bangalore, India. I am Microsoft Office Servers and Services (SharePoint) MVP (5 times). I works in SharePoint 2016/2013/2010, SharePoint Online Office 365 etc. Check out My MVP Profile.. I also run popular SharePoint web site SharePointSky.com

View all posts by Bijay Kumar →

Leave a Reply