How can I know in which content database my site collection is stored?

Question

I have a farm and I see in sql many content databases. I have some site collection and would like to find something in the userinfo table in the sql database. But in which content database do I need to look for a site collection like?

http://myCompany.com/sites/archive

Answer 1

Follow these steps:

1. Open Central Administration.
2. Application Management.
3. View all site collections.
4. Select the site collection you need to get the database name.
5. In the panel on the right you should see "Database Name", that's the name of the content database.

-Hope it helps-

Answer 2

use below PowerShell code:

$url="http://sharepoint.contoso.com/site/subsite/"
(Get-SPSite $url).ContentDatabase.name

Result should appear as:

WSS_Content_2

Answer 3

Another way via PowerShell

 $site = Get-SPSite "your site url"
 write-host $site.WebApplication.ContentDatabases

Result look like:

SPContentDatabase Name=DEV2_WSS_Content_80

Answer 4

I know this is an old post, but this will also work well:

Get-SPSite -Limit All | Where-Object{($_.URL -eq 'https://whatever.test.com/sites/sitename')} | Select-Object URL, ContentDatabase

Obviously you would replace the URL with yours. The result should look like this:

Url                                      ContentDatabase                                      
---                                      ---------------                                      
https://whatever.test.com/sites/sitename SPContentDatabase Name=WHATEVER_CONTENT_03