Rename SharePoint 2010 Central Admin database

January 9, 2012 — 1 Comment

How to rename SharePoint 2010 Central Admin Database GUID (Globally Unique Identifier)?
Is there a easy way to rename the Central Administration Content Database?

rename_sharepoint_admin_database_GUID_1

In this post you can find all the steps you needed to rename SharePoint 2010 Central Admin database with GUID to a friendly name

1. Login into SQL Server using Management Studio
2. Right click on the SharePoint 2010 Central Admin Database with GUID | Click on Rename

rename sharepoint 2010 central admin db

3. Copy the database name and past it into a notepad. Click anywhere outside of the database  to exit edit mode without changing the name

copy sharepoint 2010 central admin db name with guid

 

4. Right click on SharePoint 2010 AdminContent database which you want to rename and take a backup

rename_guid_for_sharepoint_admin_database

5. Now restore your database with new friendly name. Call it SharePoint_AdminContent_DB

restore_database_for_sharepoint_central_admin

restore_sharepoint_central_admin_database_without_guid

Now I have SharePoint AdminContent database with out GUID

SNAGHTML2f9490d3

6. Open SharePoint 2010 Central Administration | Application Management | Manage Content Database

Manage Content Database SharePoint 2010

7. Use this page to manage content databases for this web application. Click a content database name to change its properties.
Click on the database  to manage it’s settings

manage content databases SP2010

8. Specify database connection settings for this content database. Use the Database status options to control whether or not new Site Collections can be created in the database. When the database status is set to Ready, the database is available for hosting new Site Collections. When the database status is set to Offline, no new Site Collections can be created.

Click on the dropdown and make it OFFLINE

content database status offline in SharePoint 2010

9.  Do not remove the database, just click OK to make it OFFLINE

image

 

10. Open command prompt and run the stsadm command
cd C:\Program Files\Common Files\Microsoft Shared\Web server extensions\14\BIN\

chaning central admin db name using stsadm

11. Delete the original database which contain GUID by running this command.

stsadm -o deletecontentdb -url http://CentralAdminURL -databasename SharePoint_AdminContent_<GUID> –databaseserver YourSqlServer

sample Script:
stsadm -o deletecontentdb -url
http://mysp:2012 -databasename SharePoint_AdminContent_02de613c-ae5b-4617-9d88-0b53a3f6610f -databaseserver mysp

removed guid database for Sharepoint central admin

 

12. Now add the new Admin Content database with out the GUID using the following command

stsadm -o addcontentdb -url http:// CentralAdminURL:portnumber -databasename SharePoint_AdminContent_DB -databaseserver YourSQLServer

sample Script:
stsadm -o addcontentdb -url

http://mysp:2012 -databasename SharePoint_AdminContent_DB -databaseserver mysp

New Admin Content Database is added to with out GUID

sharepoint 2010 central admin guid removed

 

13. Let’s open SharePoint 2010 central administration and see what happens. Looks like SharePoint 2010 central administration is running from a new database

SNAGHTML2facc913

14. Now I am going to delete SharePoint 2010 Central Administration database with the GUID name

delete SharePoint AdminContent Database

15. One last time I am going to access central administration to make sure all are fine. Yes, it’s working now from the new database

SNAGHTML2facc913

If you follow above steps you can  rename SharePoint 2010 Central Admin Database GUID (Globally Unique Identifier

One response to Rename SharePoint 2010 Central Admin database

  1. 

    Thanks, it worked like a charm

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s