Lots of Databases in SharePoint 2010
Posted
Wednesday, October 21, 2009 3:08 PM
by
CoreyRoth
If you are like me when you get a new product, you look at every possible little thing you can find to see what’s new or different. That’s why I post this today because I figured you might be interested in what the databases might looks like in the next version. Of course, as usual this is subject to change in the future. In a typical installation, MOSS 2007 had a good number of 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_<guid> – not sure if this is for the old Business Data Catalog or not.
- Bdc_Service_db_<guid>
- Managed_Metadata_Service_<guid> – likely for the new metadata term store
- People_ProfileDb_<guid>
- People_SocialDb_<guid> – new social tagging feature
- People_SyncDb_<guid>
- People_SyncDb_<guid>_Service
- People_SyncDb_<guid>_Sync
- PerformancePoint Monitoring Service_<guid>
- Search_Service_Application_CrawlStoreDb_<guid> – labeled as admin in search dashboard
- Search_Service_Application_Db_<guid> – labeled as index in search dashboard
- Search_Service_Application_PropertyStoreDb_<guid> – labeled as query in search dashboard
- Secure_Store_Service_Db_<guid>
- SharePoint_AdminContent_<guid> – CA database
- SharePoint_Config
- SSO
- StateService_<guid>
- Web AnalyticsServiceApplication_Reporting_Db_<guid>
- Web AnalyticsServiceApplication_Staging_Db_<guid>
- Word Automatiation Services_<guid>
- WSS_Content – content database
- WSS_Logging – likely for analytics
As you can see you have more databases to backup now.