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 Name | Brief Description |
---|---|
SP2010_Farm_Config | Farm 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_Content | Central 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_Content | Content 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_Content | Same as above |
SP2010_Farm_Logging_Config | Usage 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_Service | User 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_Service | User 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_Service | User 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_Service | Managed Metadata database The Managed Metadata service application database stores managed metadata and syndicated content types. |
SP2010_Farm_Search_Service | Search 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_Service | Search service application Crawl database The Crawl Databases host the crawled data and drives crawl |
SP2010_Farm_SearchProperty_Service | Search 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_Service | Web 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_Service | Web 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_Service | Secure Store database The Secure Store service application database stores and maps credentials, such as account names and passwords. |
SP2010_Farm_State_Service | State database The State service application database stores temporary state information for InfoPath Forms Services, the chart Web Part, and Visio Services. |
SP2010_Farm_Usage_Service | Usage Service database |
SPS2010_Farm_AppRegistry_Service | Application 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_Service | Business Data Connectivity database The Business Data Connectivity service application database stores external content types and related objects. |
SPS2010_Farm_AppRegistry_Service | Application 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_Service | PerformancePoint service application database The PerformancePoint service application database stores temporary objects, persisted filter values, and user comments. |
SPS2010_Farm_PowerPivot_Service | PowerPivot 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