Share via

Renaming the SharePoint Central Administration Content Database (SharePoint_AdminContent)

  • Article

Installing SharePoint using the GUI works really well and makes the install process pretty simple. Using the Command Prompt to perform the install on the other hand probably gives you a better sense for what is being done. It certainly gives you more control over the naming of things like databases and application pools. One in particular is the SharePoint Central Administration site collection's content database. By default it is named by concatenating "SharePoint_AdminContent_" with a newly generated GUID.

This Central Admin content database name may not be aesthetically pleasing, or DBAs may have different naming conventions or standards they will want this database to follow. All is not lost if you have used the setup wizard GUI and SharePoint has generated a database with a name like this. Content databases can be renamed by backing up and restoring the database with the new name, and then removing the old one from the web application and adding the new one in its place.

Unlike renaming regular web applications, it is best to remove the old content database and add the database restored with the new name using the Command Prompt. There is a Content Databases section in Central Administration, but in this case the content database is the same one on the backend that hosts Central Administration and that section.

Following are the steps I find work best for me when I need to rename the Central Administration content database:

  1. Stop the Central Administration application pool in IIS. This will prevent data loss and ensure no one else is performing operations while the content database is adjusted.
    By default, the Central Administration application pool is called "SharePoint Central Administration v3" in IIS.
  2. Backup the Central Administration content database using SQL Server Management Studio. I backed up the database "SharePoint_AdminContent_b73dd91a-a0f2-4d8bad9f-ba4ab59a4de3" in this example.
  3. Restore the previously backed up Central Administration content database to a new database using a new name. I restored that database with the name "SharePoint_AdminContent" (without the GUID) in this example.
  4. Open a Command Prompt window under the context of the SharePoint server farm account. This is the same account used as the identity of the Central Administration application pool.
    The easiest way is to right-click the Command Prompt in the start menu, then choose "Run As" and enter the service account's credentials.
  5. Enter the STSADM command in the Command Prompt window using the "deletecontentdb" option. For example, I entered the following STSADM command:
    stsadm -o deletecontentdb -url https://Example:41000/ -databasename SharePoint_AdminContent_b73dd91a-a0f2-4d8bad9f-ba4ab59a4de3
  6. Enter another STSADM command using the "addcontentdb" option. For example, I entered the following STSADM command:
    stsadm -o addcontentdb -url https://Example:41000/ -databasename SharePoint_AdminContent
  7. Delete the old content database. I deleted "SharePoint_AdminContent_b73dd91a-a0f2-4d8bad9f-ba4ab59a4de3" in this example.
  8. Restart the Central Administration application pool in IIS (SharePoint Central Administration v3).

Comments

  • Anonymous
    December 09, 2007
    PingBack from http://msdnrss.thecoderblogs.com/2007/12/09/renaming-the-sharepoint-central-administration-content-database-sharepoint_admincontent/

  • Anonymous
    December 10, 2007
    OK, so what's the PSConfig command to install SP and create this DB so you don't have to do this rename step?

  • Anonymous
    August 13, 2009
    Hi Steve, I have tried what you have put but when trying to delete the contentdb i get error that says the <databasename> is not assoicated with the web. also get error "access denied" when trying add the newly restored database with the new name minus the guid. can you please help?

  • Anonymous
    January 30, 2010
    Hi rjamgotre - the account you run the command under requires write access to the configuration database, otherwise you'll get that access denied error. Try running the command prompt using Run As and logging in as the SharePoint farm service account.