Thursday, December 10, 2009

SharePoint 2010 - Databases

It looks like SharePoint 2010 more than doubles the number. My particular installation had 22 databases. I think this number can even grow even more as you activate more Service Applications. Most of the names are obvious, but I have commented on a few of them. Some of the databases have spaces in their names. The names are determined based upon how the service application was named.


• Application_Registry_Service_ – not sure if this is for the old Business Data Catalog or not.
• Bdc_Service_db_
• Managed_Metadata_Service_ – likely for the new metadata term store
• People_ProfileDb_
• People_SocialDb_ – new social tagging feature
• People_SyncDb_
• People_SyncDb__Service
• People_SyncDb__Sync
• PerformancePoint Monitoring Service_
• Search_Service_Application_CrawlStoreDb_ – labeled as admin in search dashboard
• Search_Service_Application_Db_ – labeled as index in search dashboard
• Search_Service_Application_PropertyStoreDb_ – labeled as query in search dashboard
• Secure_Store_Service_Db_
• SharePoint_AdminContent_ – CA database
• SharePoint_Config
• SSO
• StateService_
• Web AnalyticsServiceApplication_Reporting_Db_
• Web AnalyticsServiceApplication_Staging_Db_
• Word Automatiation Services_
• WSS_Content – content database
• WSS_Logging – likely for analytics

No comments:

Post a Comment

Posting is provided "AS IS" with no warranties, and confers no rights.