:) SharePoint database naming standards

ArticleDirectory

• Naming Convention
• Implementing the naming convention
• Conclusion

SharePoint database naming standards

Call me picky, but I think it's important to consistently name your SharePoint databases-especially on a shared SQL server hosting multiple farms and applications. not only is it a good practice, but by showing that you care about the databases, you'll earn the respect of even your most grumpiest DBAs. I wish the SharePoint administrative interfaces ushered you into a naming convention, but the rea Lity is that consistent naming requires diligence and a little planning. I wocould bet that a majority of the SharePoint installations in the wild were configured using the products and technology wizard GUI. when you use the GUI, it creates the central administration content database without giving you the opportunity to provide a meaningful name. if you 've seen a database named into point_ad Mincontent _ [yourguidhere], you know what I'm talking about. Imagine you are supporting multiple SharePoint farms-is it easy to tell which database belongs to which farm? Shouldn't it be?

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 wowould 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_defassp SSP	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_defassp SSP	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.

Implementing the naming convention

The best way to ensure consistency isScript configuration changes. I use powershell to tear down and build up my development environment, and I use the same approach to make changes to production servers. in a future post, I will provide a sample, but essential, I create a script that takes an environment-specific xml configuration file as a parameter. for example:

Provision-Farm.ps1 johnpowell. Development. xml

If you are lucky and brilliant enough to have a naming convention in place before the farm has been configured, it is much easier to implement the database naming convention. implementing a standard after the fact will require additional steps. so let's suppose you just installed the SharePoint bits and are ready to configure Sharepoint. stop! Rather than use the GUI, use psconfig from the command line. this enables you to control the central administration content database name. for example, to create the configuration and CA database, use the following command:

Psconfig.exe-cmd configdb-create-server sqlcluster.aw.com-Database Sharepoint_awintranet_config-user SVC-SP-aw-farm-PasswordPass @ word1-Admincontentdatabase extends point_awintranet_content_ca

But what if you have an existing farm? In that case, this post describes how to rename the central administration content database and this post outlines the procedure for renaming other content databases.

Conclusion

It is good practice to have a database naming convention, and to define and document it during the planning phase. although the SharePoint administrative interfaces do not enforce a database naming convention, with a little planning and governance you can implement a standard. once a standard is defined, scripting configuration changes is the best way to ensure they are implemented consistently. for example, you cocould have a scriptCreate-WebApplication.ps1That takes a few parameters and implements your naming convention. SharePoint 2010 hasSignificantlyMore databases that 2007, making database naming even more important. So here are your "Go DoS :"

• Define and document a database Naming Standard
• Create scripts to implement your standards
• Evaluate existing farms against your standards, and create a plan to rename them