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. 

Comments

# Twitter Trackbacks for Lots of Databases in SharePoint 2010 - Corey Roth - DotNetMafia.com - Tip of the Day [dotnetmafia.com] on Topsy.com

Pingback from  Twitter Trackbacks for                 Lots of Databases in SharePoint 2010 - Corey Roth - DotNetMafia.com - Tip of the Day         [dotnetmafia.com]        on Topsy.com

# Social comments and analytics for this post

Saturday, October 24, 2009 2:14 PM by uberVU - social comments

This post was mentioned on Twitter by coreyroth: #spc09 Post: So many more databases to keep track of (and backup)! http://tinyurl.com/yjs35n9 #sp2010

# SharePoint Single Point of Failure &raquo; A Busy Week in the SharePoint World

Pingback from  SharePoint Single Point of Failure &raquo; A Busy Week in the SharePoint World

# A Busy Week in the SharePoint World &laquo; The SharePoint Mechanic

Thursday, February 11, 2010 10:58 PM by A Busy Week in the SharePoint World « The SharePoint Mechanic

Pingback from  A Busy Week in the SharePoint World &laquo; The SharePoint Mechanic

Leave a Comment

(required) 
(required) 
(optional)
(required)