Un interesante articulo de Hector Insua.

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