Friday, September 20, 2013

Rename Admin Content database in SharePoint 2013

Normally, When we install SharePoint 2013 using SharPoint Configuration wizards the Central Administration Web Application is provisioned with
the database. The admin database name is generated automatically with a GUID.
For example, in my instance it has created with the following name,
Admin_Content_bbceaf91-431d-461a-9c91-c89ed4c21e59

The following steps will help the SharePoint Administrator to rename the Admin content database to a proper format.

Open the SharePoint Management Powershell (Run AS Administrator)

List of Commands to be used to rename the Central Admin Database
1. Create a new Central Administration Content Database
New-SPContentDatabase -Name SharePoint_AdminContent -WebApplication http://centralAdminsite:Port

2. Get a list of Central Administration Content Databases
Get-SPWebApplication -Identity http://centraladminsite:port | Get-SPContentDatabase | Select Id, Name, WebApplication
| Format-List

Copy database content
Get-SPSite -ContentDatabase oldadmin content database ID GUID | Move-SPSite -DEstinationDatabase newadmindatabase ID Guid

Ensure you can access the central admin web site in Internet Explorer.

Delete the old database
Remove-SPContentDatabase oldadmin content database ID GUID

Confirm the old database has been removed from SharePoint
Get-SPWebApplication -Identity http://centraladminsite:port | Get-SPContentDatabase |Select Id, Name,
WebApplication | Format-List

1 comment:

  1. hello, also u can a use another process:

    use get-SpDatabase to get the guid of the central admin content database

    use Dismount-SPContentDatabase

    go to sql, put the database in single user mode and rename.

    then use Mount-SPContentDatabase-DatabaseServer-WebApplication



    cheers

    ReplyDelete