{"id":1661,"date":"2013-07-01T09:52:21","date_gmt":"2013-07-01T09:52:21","guid":{"rendered":"https:\/\/poiseddevelopers.com\/reality-tech\/?p=1661"},"modified":"2024-05-13T10:45:16","modified_gmt":"2024-05-13T10:45:16","slug":"sharepoint-database-naming","status":"publish","type":"post","link":"https:\/\/poiseddevelopers.com\/reality-tech\/sharepoint-database-naming\/","title":{"rendered":"SharePoint Database Naming"},"content":{"rendered":"<p>The primary naming convention to put in place is the Database Naming standard.\u00a0 By default, SharePoint puts a GUID at the end of every database.<\/p>\n<p>This is to ensure that two SharePoint farms can use the same database server without conflict. However the GUIDs make memorizing a database name practically impossible.<\/p>\n<p>Here are some basic naming conventions to consider adopting:<\/p>\n<ul>\n<li>Avoid GUIDs at all costs<\/li>\n<li>Avoid blanks<\/li>\n<li>Avoid underscores<\/li>\n<li>Leave \u201cDB\u201d and \u201cdatabase\u201d out of the name<\/li>\n<li>Use Capital Letters to highlight the start of words (CamelCase)<\/li>\n<li>Consistent description to allow a database to be clearly associated with a specific Web App and Service App<\/li>\n<li>References to Production vs. Development are not necessary<\/li>\n<li>References to SharePoint version are not necessary<\/li>\n<li>References to \u201cSharePoint\u201d are unnecessary, especially for a dedicated SQL Server<\/li>\n<li>Leave the obscure \u201cWSS\u201d SharePoint convention for content databases, instead use \u201cContent\u201d at the start of the database name.\u00a0 That\u2019s clearer for DBAs who are not versed in the mysterious acronyms of SharePoint.<\/li>\n<\/ul>\n<p>Here\u2019s a proposed syntax for structuring database names:<\/p>\n<p><b>[Major Application][Type] [Minor Application] [Specific]<\/b><\/p>\n<table style=\"border-collapse: collapse; width: 100%; border: 2px solid #dddddd; text-align: left; padding: 8px;\">\n<tbody>\n<tr style=\"background-color: #f2f2f2;\">\n<th style=\"border: 1px solid #dddddd; text-align: left; padding: 8px;\">Component<\/th>\n<th style=\"border: 1px solid #dddddd; text-align: left; padding: 8px;\">Description<\/th>\n<th style=\"border: 1px solid #dddddd; text-align: left; padding: 8px;\">Sample Values<\/th>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #dddddd; text-align: left; padding: 8px;\">[Major Application]<\/td>\n<td style=\"border: 1px solid #dddddd; text-align: left; padding: 8px;\">Major category of Application<\/td>\n<td style=\"border: 1px solid #dddddd; text-align: left; padding: 8px;\">[left blank for SharePoint]<br \/>\nMSPS (for MS Project Server)<\/td>\n<\/tr>\n<tr style=\"background-color: #f2f2f2;\">\n<td style=\"border: 1px solid #dddddd; text-align: left; padding: 8px;\">[Type]<\/td>\n<td style=\"border: 1px solid #dddddd; text-align: left; padding: 8px;\">Category or type of database, based on primary system using the database<\/td>\n<td style=\"border: 1px solid #dddddd; text-align: left; padding: 8px;\">Content<br \/>\nServiceApp<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #dddddd; text-align: left; padding: 8px;\">[Minor Application]<\/td>\n<td style=\"border: 1px solid #dddddd; text-align: left; padding: 8px;\">Can be Service Application<\/td>\n<td style=\"border: 1px solid #dddddd; text-align: left; padding: 8px;\">PerformancePoint<br \/>\nManagedMetadata<\/td>\n<\/tr>\n<tr style=\"background-color: #f2f2f2;\">\n<td style=\"border: 1px solid #dddddd; text-align: left; padding: 8px;\">[Specific]<\/td>\n<td style=\"border: 1px solid #dddddd; text-align: left; padding: 8px;\">Can describe each of multiple service app DBs. Description of use of Content DB for Web App<\/td>\n<td style=\"border: 1px solid #dddddd; text-align: left; padding: 8px;\">CentralAdmin<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>Examples<\/h3>\n<p>Default: Search_Connector_CrawlStoreDB_4040b7300e9e42779edb3e6b926be5a7<\/p>\n<p>New: ServiceApp_SearchConnectorCrawlStoreDB<\/p>\n<p>Default: SharePoint_AdminContent_ff35d171-482c-4f9d-8305-a4a259ec1a15<\/p>\n<p>New: Content_CentralAdmin<\/p>\n<p>Default: wss_content_eaee9d8f-ed75-4a56-bad3-5abf232b4f66<\/p>\n<p>New: Content_ DIV_HR<\/p>\n<p>Default: StateService_0f2a42e8b90d4c60830ca442e753de13<\/p>\n<p>New: ServiceApp_State<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The primary naming convention to put in place is the Database Naming standard.\u00a0 By default, SharePoint puts a GUID at the end of every database. This is to ensure that two SharePoint farms can use the same database server without conflict. However the GUIDs make memorizing a database name practically impossible. Here are some basic [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":1665,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[25],"tags":[],"class_list":["post-1661","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-architecture"],"acf":[],"_links":{"self":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts\/1661","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/comments?post=1661"}],"version-history":[{"count":6,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts\/1661\/revisions"}],"predecessor-version":[{"id":3956,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts\/1661\/revisions\/3956"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/media\/1665"}],"wp:attachment":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/media?parent=1661"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/categories?post=1661"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/tags?post=1661"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}