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?
Follow these steps:
- Open Central Administration.
- Application Management.
- View all site collections.
- Select the site collection you need to get the database name.
- In the panel on the right you should see "Database Name", that's the name of the content database.
-Hope it helps-
use below PowerShell code:
$url="http://sharepoint.contoso.com/site/subsite/" (Get-SPSite $url).ContentDatabase.name
Result should appear as:
Another way via PowerShell
$site = Get-SPSite "your site url" write-host $site.WebApplication.ContentDatabases
Result look like: