1

I am trying to rename database SharePoint Admin Content database for that I am using below PowerShell commands in SharePoint 2019

New-SPContentDatabase -Name SharePoint_AdminContent -WebApplication http://sp2010-web1:20376
Get-SPWebApplication -Identity http://sp2010-web1:20376 | Get-SPContentDatabase | Select Id, Name, WebApplication | Format-List
Get-SPSite -ContentDatabase 46410944-32c4-4e01-8390-22b693f4fcc2 | Move-SPSite -DestinationDatabase 86d8e579-fbd8-473e-867d-58b974ee0267

But on the last line, I am getting below error

enter image description here

I also try to upgrade both content databases but it also tells me that upgrade is not needed

enter image description here

I patch my SharePoint 2019 with KB4484271 but still, I have the same issue.

enter image description here

Can somebody help me resolve this issue.

Improve this question
4
  • Any help will be appriciated – Milind Apr 18 '20 at 16:20
  • How many servers in your farm? Have you run the SharePoint Configuration wizard on all SP servers after installing the SharePoint updates? if your goal is just to rename the content database why you didn't dismount the content database from a web application and then rename it after that mount it again? – Mohamed El-Qassas MVP♦ Apr 19 '20 at 20:03
  • 1 Front-End with Distributed Cache, 2 Application and 1 Search Server. Yes I have ran PSCONFIG GUI and run well. I am afraid dismount and mount can damage my SharePoint Farm. – Milind Apr 19 '20 at 21:41
  • Take a backup before doing that – Mohamed El-Qassas MVP♦ Apr 19 '20 at 21:47
1

Please go to Central Admin> Under “Upgrade and Migration”> Click on “Review database status“ to check the database upgrade status.

Or install the latest security update for SharePoint Server 2019 to compare the result.

Then refer to below article to rename the Admin Content Database in SharePoint 2016/2019 using PowerShell:

https://veronicageek.com/sharepoint/sharepoint-2013/rename-admin-content-database-sharepoint-2016-using-powershell/2017/12/

Another way to rename the content databse is to dismount and mount the renamed database again:

https://www.winsysadminblog.com/2016/03/how-to-rename-a-sharepoint-2013-content-database-name-hosted-on-sql-server/

Improve this answer
2
  • I have review database, status is no action required, I have tried first link it did not help. I will try second one. and let you know – Milind Apr 20 '20 at 7:14
  • This link works winsysadminblog.com/2016/03/… for me – Milind Apr 20 '20 at 9:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.