SharePoint 2010 Database Naming Conventions

SharePoint 2010 Database Naming Standards/Conventions

When it comes to SharePoint database naming standards, There are lot of patterns used by SharePoint Admins. Yes, it is a good practice to have a database naming convention. Not only just a good practice, but it will be good for your DBAs as well :-). and here goes mine.

Pattern:  SP2010_ + Scope (such as Farm, Sales, IT, etc) + _Database Type (Config , Content, Service)

Database NameBrief Description
SP2010_Farm_ConfigFarm Configuration
The configuration database contains data about SharePoint databases, Internet Information Services (IIS) Web sites, Web applications, trusted solutions, Web Part packages, site templates, and Web application and farm settings specific to SharePoint 2010 Products, such as default quota settings and blocked file types.
SP2010_Farm_Admin_ContentCentral Administration content
The Central Administration content database is considered to be a configuration database. It stores all site content, including site documents or files in document libraries, list data, and Web Part properties, in addition to user names and rights for the Central Administration site collection. If Microsoft SQL Server PowerPivot for Microsoft SharePoint is installed, the Central Administration content database also stores the Excel worksheets and PowerPivot data files used in the PowerPivot Management Dashboard.
SP2010_Portal_ContentContent databases
Content databases store all content for a site collection, including site documents or files in document libraries, list data, Web Part properties, audit logs, and sandboxed solutions, in addition to user names and rights. 
SP2010_Partner_ContentSame as above
SP2010_Farm_Logging_ConfigUsage and Health Data Collection database
The Usage and Health Data Collection database is used by the Usage and Health Data Collection service application. It stores health monitoring and usage data temporarily, and can be used for reporting and diagnostics. 
SP2010_Farm_UserProfileSocial_ServiceUser Profile service application Social Tagging database
The Social Tagging database stores social tags and notes created by users, along with their respective URLs.
SP2010_Farm_UserProfileSynch_ServiceUser Profile service application Synchronization database
The Synchronization database stores configuration and staging data for use when profile data is being synchronized with directory services such as Active Directory.
SP2010_Farm_UserProfile_ServiceUser Profile service application Profile database
The Profile database stores and manages users and associated information. It also stores information about a user’s social network in addition to memberships in distribution lists and sites.
SP2010_Farm_ManagedMetadata_ServiceManaged Metadata database
The Managed Metadata service application database stores managed metadata and syndicated content types.
SP2010_Farm_Search_ServiceSearch service application Administration database
The Administration database hosts the Search service application configuration and access control list (ACL), and best bets for the crawl component. This database is accessed for every user and administrative action. 
SP2010_Farm_SearchCrawl_ServiceSearch service application Crawl database
The Crawl Databases host the crawled data and drives crawl
SP2010_Farm_SearchProperty_ServiceSearch service application Property database
The Property database stores information that is associated with the crawled data, including properties, history, and crawl queues.
SP2010_Farm_WebAnalyticsReporting_ServiceWeb Analytics Reporting database
The Reporting database stores aggregated standard report tables, fact data aggregated by groups of sites, date and asset metadata, and diagnostics information for the Web Analytics service application.
SP2010_Farm_WebAnalyticsStaging_ServiceWeb Analytics Staging database
The Staging database temporarily stores un-aggregated fact data, asset metadata, and queued batch data for the Web Analytics service application.
SP2010_Farm_SecureStore_ServiceSecure Store database
The Secure Store service application database stores and maps credentials, such as account names and passwords.
SP2010_Farm_State_ServiceState database
The State service application database stores temporary state information for InfoPath Forms Services, the chart Web Part, and Visio Services.
SP2010_Farm_Usage_ServiceUsage Service database
SPS2010_Farm_AppRegistry_ServiceApplication Registry database
The Application Registry service application database stores backward-compatible information that is used to connect to information that is used by the Microsoft Office SharePoint Server 2007 Business Data Catalog API. 
SPS2010_Farm_BCS_ServiceBusiness Data Connectivity database
The Business Data Connectivity service application database stores external content types and related objects.
SPS2010_Farm_AppRegistry_ServiceApplication Registry database
The Application Registry service application database stores backward-compatible information that is used to connect to information that is used by the Microsoft Office SharePoint Server 2007 Business Data Catalog API. 
SPS2010_Farm_PPS_ServicePerformancePoint service application database
The PerformancePoint service application database stores temporary objects, persisted filter values, and user comments.
SPS2010_Farm_PowerPivot_ServicePowerPivot Application database
The PowerPivot Application database stores the location of cached or loaded PowerPivot data files, data refresh schedules, and PowerPivot usage data that is copied from the central usage data collection database.

Get rid of GUIDs:
https://msmvps.com/blogs/shane/archive/2010/10/26/getting-rid-of-guids-in-sharepoint-2010-database-names.aspx

Salaudeen Rajack

Salaudeen Rajack - Information Technology Expert with Two-decades of hands-on experience, specializing in SharePoint, PowerShell, Microsoft 365, and related products. He has held various positions including SharePoint Architect, Administrator, Developer and consultant, has helped many organizations to implement and optimize SharePoint solutions. Known for his deep technical expertise, He's passionate about sharing the knowledge and insights to help others, through the real-world articles!

Leave a Reply

Your email address will not be published. Required fields are marked *