When I use Get-SPWebApplication command on sharepoint sever got 9 web applications names.When I use Get-SPContentDatabase got 15 content databases.How this mismatch happened??any idea???

2 Answers 2


Some web application might have multiple Content Database, you can execute the same command again with Format Table

Get-SPContentDatabase | FT

This command will return the result in Table format, so that you can easily identify the web application by name


This is because, one web application can connect to multiple content databases. So mismatch means, you have multiple databases in the web applications. You can check it via Central admin or run the below powershell.

Get-SPContentDatabase | select WebApplication, Name, CurrentSiteCount

Note: One content database only attach to single web application.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.