Nomenclaturas para las Bases de datos de SharePoint

Hace unos dias hablaba precisamente de esto con un cliente, SharePoint maneja varias bases de datos y cuando estamos en una estructura de Varios Sitios y Colecciones de Sitios, SSPs y demas, visualizar el SQL y entender que es lo que significa cada base puede resultar caotico, al punto de llegar a eliminar bases de datos o hacerles un dettach para ver que deja de funcionar… (Asi ocurre) asi que por casualidad me encontre hoy con un interesante articulo, que propone un sistema de nomenclatura para SharePoint, en lo personal utilizo un esquema muy parecido, vean esto :

Naming Convention

Here is the naming convention I recommend for SharePoint 2007:

SharePoint_[Farm Name]_[Database Type]_[Name] where database type is one of the following:

• Config
• Content
• WSSSearch
• SSP
• SSPSearch

For example, the AdventureWorks MOSS 2007 Enterprise Intranet farm would have the following databases:

Database
Purpose

SharePoint_AWIntranet_Config
Farm Configuration

SharePoint_AWIntranet_Content_CA
Central Administration Content

SharePoint_AWIntranet_Content_Intranet
Company Intranet Content

SharePoint_AWIntranet_Content_DefaultSSP
Default SSP Content

SharePoint_AWIntranet_Content_DefaultSSPMySite
My Site Content for Default SSP

SharePoint_AWIntranet_Content_OtherSSP
Other SSP Content

SharePoint_AWIntranet_Content_OtherSSPMySite
My Site Content for Other SSP

SharePoint_AWIntranet_SSP_DefaultSSP
Default SSP Database

SharePoint_AWIntranet_SSP_OtherSSP
Other SSP Database

SharePoint_AWIntranet_SSPSearch_DefaultSSP
Default SSP Search Database

SharePoint_AWIntranet_SSPSearch_OtherSSP
Other SSP Search Database

SharePoint_AWIntranet_WSSSearch_SPWFE01
WSS Help Search Web Front End 1

SharePoint_AWIntranet_WSSSearch_SPWFE02
WSS Help Search Web Front End 2

What I like about this naming convention is that the databases sort nicely.  On a shared SQL Server, the SharePoint databases are separated from other application databases.  Within SharePoint, each farm’s databases are together.  Within each farm, the database types are together, and finally, a meaningful name makes it easy to determine which area it belongs to.

El articulo Original esta sumamente interesante, pueden verlo aqui : http://blogs.msdn.com/johnwpowell/archive/2009/12/15/sharepoint-database-naming-standards.aspx