All databases utilized by SharePoint - creating list for reference

Have you ever wondered how to list all Databases utilized by SharePoint. I was creating this list and had really difficulty to find all configuration, content and search DB - tried from Centeral Admin console as well as tried various STSADM commands. I was able to find all DB names - but had to look in many places.

So in search of central place to list all these databases, came across this page on Central Admin, where all farm configuration (config, content, SSP - search and content, web app content) was listed with corresponding database.

This list is available with Backup option. From Central Admin - Operations - Perform a Backup (under Backup and Restore).

On this page, you will see list of all farm settings and related database names. Creating list for your reference will be really easy from this page.

Edit (11/5/2009) - another easy way to get this list of SharePoint DB will be use STSADM command with showtree switch :

From 12\bin directory, run following command - it will give you same list as shown by backup option from CA :

stsadm -o backup -showtree

You can re-direct this output to text file which can help you to list this databases for reference.

For more detailed information on these databases - refer to this Microsoft article on Back-end Protocols - really detailed info on all back-end application (including for SharePoint 2010).