Rename SharePoint database names to get rid of guid.

Question

We are working on setup of SharePoint Application using SharePoint Subscription Edition.

 

Our application includes SharePoint Workflow service and User Profile service, with other services too.

 

We need to rename below 4 databases of Workflow , User Profile services.

 

1> SbManagementDB ( This is Workflow service database for service bus)

2> WFManagementDB (This is Workflow service main database)

3> Sync_12f4ae5f-a29c-4ead-b3af-d23be1e8322b ( 1 of database for User Profile service to sync activity)

4> Admin content database

5> SharePoint_Config

 

Request you to provide -

a) suitable approach to rename these databases.

b) PowerShell script for renamed database to point with respective services too.

I referred article: https://learn.microsoft.com/en-us/sharepoint/administration/move-or-rename-service-application-databases#steps-to-move-or-rename-the-search-service-application-databases-in-sharepoint-server-2013-and-sharepoint-server-2016

Which is bit confusing for me or not clear for me.

Thank you in advance. :)

Answer 1

Hi @Sudhir Singare,

To rename the SharePoint databases, you can follow these general steps:

1. Stop the Service Applications: Before renaming the databases, you need to stop the respective service applications associated with the databases you wish to rename.
2. Detach the Databases: Use SQL Server Management Studio to detach the databases that you want to rename.
3. Rename the Databases: After detaching, you can rename the databases using SQL Server Management Studio.
4. Reattach the Databases: Once renamed, reattach the databases to the SQL Server instance.
5. Point the Service Applications to the Renamed Databases: Use either Central Administration or PowerShell to point the service applications to the newly renamed databases.

Use

Get-SPDatabase | where {$_.Type -notcontains "Content Database" -and $_.Type -notcontains "Configuration Database"} | sort Type | format-table –autosize

to get service application databases.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.