:) SharePoint database naming standards

Source: Internet
Author: User
Tags server hosting
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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.