in

Dot Net Mafia

Group site for developer blogs dealing with (usually) .NET, SharePoint 2013, SharePoint 2010, Office 365, SharePoint Online, and other Microsoft products, as well as some discussion of general programming related concepts.

This Blog

Syndication

Archives

Corey Roth [MVP]

A SharePoint MVP bringing you the latest time saving tips for SharePoint 2013, Office 365 / SharePoint Online and Visual Studio 2013.

Lots of Databases in SharePoint 2010

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 said:

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

October 21, 2009 3:46 PM
 

uberVU - social comments said:

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

October 24, 2009 2:14 PM
 

SharePoint Single Point of Failure » A Busy Week in the SharePoint World said:

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

January 4, 2010 6:39 PM
 

A Busy Week in the SharePoint World « The SharePoint Mechanic said:

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

February 11, 2010 10:58 PM

Leave a Comment

(required)  
(optional)
(required)  
Add

About CoreyRoth

Corey Roth is an independent SharePoint consultant specializing in ECM, Apps, and Search.
2015 dotnetmafia.
Powered by Community Server (Non-Commercial Edition), by Telligent Systems