SharePoint 2010 Database Names

While SharePoint Server 2010 has several enhancements for Administrators including such capabilities of an offline database restoring a list item or document, there are still some curiosities that I’ve got as to the planning of the underlying system.

For instance, it would seem that for such a refined product with so many enhancements that items such as the underlying databases might follow a naming convention of some sort. For a standard SharePoint Server 2010 Enterprise edition installation, out of the box you’ll have the following databases:

Managed Metadata Service_GUID
PerformancePoint Service Application_GUID
User Profile Service Application_ProfileDB_GUID
User Profile Service Application_SocialDB_GUID
User Profile Service Application_SyncDB_GUID

As you can see, the naming convention seems to vary dependent on the team within the product group that was developing the capability, feature set or workload.  For instance, some of the databases include an “_DB"_” and other times the database name has a concatenation of the “DB”.  Further, it’s interesting in seeing how they delineate words, in some instances using spaces, others underscores and others just capitalization of letters to delineate the database.

Interesting that it wasn’t polished to be uniform eh?

By Dan

A network engineer that's taken an interest in the SharePoint platform, architecting, designing and implementing collaboration tools to help organizations work a little better and lower the stress levels of employees.

I'm a huge fan of classical music, iced tea, and the sound of the ocean - great way to enjoy life if you ask me.

2 replies on “SharePoint 2010 Database Names”

Leave a Reply to Tweets that mention SharePoint 2010 Database Names -- Cancel reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s