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
hello, also u can a use another process:
ReplyDeleteuse 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