Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

How to find the list of databases are used by a SharePoint 2010 Farm, including content databases, service application databases and configuration database.

share|improve this question

5 Answers 5

up vote 5 down vote accepted

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

share|improve this answer
    
Get-SPDatabase | Export-Csv c:\sharepointDbs.csv –  imanabidi Mar 15 at 7:56

Try SharePoint PowerShell: Get-SPDatabase

http://njbblog.blogspot.com/2011/03/sharepoint-40-powershell-get-spdatabase.html

share|improve this answer

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

share|improve this answer

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

share|improve this answer

this command get-spdatabase was listing some databases that were already deleted. How to solve this? I want to list just the correct databases. I know the Exists property, but in my case the command are listing databases that not exist more in SQL Server.

For example, I changed the database's name of the "Secure Store Service" service application from "Secure_Store_Service_Bd_{guid}" to "SP2010_SECURE_STORE_SERVICE".

In Central administration the correct name appears. In SQL Server I had to delete this old database using Management Studio . In PowerShell, the command get-spdatabase is listing the old database name as an existing database yet.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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