How to find the list of databases are used by a SharePoint 2010 Farm, including content databases, service application databases and configuration database.
4 Answers
If you want to know databases in your farm instance, use Get-SPDatabase as suggested by another answer.
If you want to understand what databases sharepoint creates and what exactly sharepoint stores in them, check Databases That Support SharePoint 2010 Products
-
2
Try SharePoint PowerShell: Get-SPDatabase
http://njbblog.blogspot.com/2011/03/sharepoint-40-powershell-get-spdatabase.html
Why not simply using Central Admin... :-) (works even if you do NOT have access to either the physical server (console) or databases server.
Central Admin -> Upgrade and Migration -> Review Database Status. By pasting /_admin/DatabaseStatus.aspx at your CA url.
Rgds, Arjan Vos
You can this resource. It's very clear from size, name, attribute to capability of backup/restore by other tools.http://technet.microsoft.com/en-us/library/cc678868.aspx