Restore SharePoint database 2019

Question

In SharePoint 2019, I have two environments, I want to restore content database that already exists on the production farm to the staging farm without deleteting the current site collection database How should the site collection be migrated to the newly restored database in Sharepoint 2019?

• The current content database name is: WSS_Content_V1, and the resored name is : WSS_Content_V2.

Answer 1

How to restore SharePoint Content Database in SharePoint 2019?

You may restore the database without any problems by performing the below steps:

Prerequisites:

• It is recommended that you take a backup of the current database for the rollback plan before restoring the database on SQL Server.
• Make sure that the current build number of the target farm is the same or higher than the current SharePoint farm build number to avoid this error Your backup is from a different version of SharePoint Foundation and cannot be restored.
• Also, you can use the database attach upgrade method to move a site collection to another farm as mentioned at Backup and Restore SharePoint Web Application to another Farm.

After taking the backup follow the instructions below:

1. Restore the database on SQL Server.

2. Get the list of all site collections that is stored on content database. We will use the results of this command to verify the resorting:

   Get-SPContentDatabase | where {$_.Name -eq "WSS_Content_V1" } | select Sites | Format-List

3. Run Dismount-SPContentDatabase command with database name:

   Dismount-SPContentDatabase WSS_Content_V1

4. Run Mount-SPContentDatabase command with the restored database and the WebApplication name:
   Mount-SPContentDatabase WSS_Content_V2 -WebApplication {siteURL}

5. if the command run successfully you will get this output.
   

6. Get the list of all site collections that is stored on content database that has been Migrated. (This stage is to see if your migration plan is working properly)

   Get-SPContentDatabase | where {$_.Name -eq "WSS_Content_V2" } | select Sites | Format-List

---

See Also

• Backup and Restore Site Collection SharePoint 2019
• Backup and Restore SharePoint 2019 Web Application to another Farm