Share via

SharePoint: Restoring an SharePoint 2016 content database on a new Site Collection on an existing SharePoint 2019 web application

Umar Khan 21 Reputation points
2020-09-17T08:16:05.217+00:00

Hello Everyone,

I am looking to restore and mount a site collection from a SharePoint 2016 environment to a SharePoint 2019 environment.
I already have a web application with site collection running on SharePoint 2019 farm (http://webapp.domain.com) and I need to mount SP2016 content database to a new site collection in the same web application as http://webapp.domain.com/site2.

Is there any way to mount the database to the http://webapp.domain.com/site2 site collection without affecting the site running on http://webapp.domain.com.

Microsoft 365 and Office | SharePoint Server | For business
0 comments
Accepted answer
  1. trevorseward 11,711 Reputation points
    2020-09-17T13:55:20.37+00:00

    You mount databases against a Web Application, not site collection. If the Site Collection in 2016 is at "/", what you would want to do in 2016 is backup and restore the site collection to a new content database in the desired path (i.e. /sites/site2). When that is done, mount that new database on 2019.

    This ensures the path is what you want it, and by using Backup-SPSite/Restore-SPSite, it generates a new Site ID which are unique per-farm.

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Chelsea Wu 6,341 Reputation points Moderator
    2020-09-18T09:55:54.03+00:00

    In addition to trevorseward’s Answer, here are some articles you can refer to for this process:

    1. In SharePoint Server 2016, backup a site collection using PowerShell: Backup-SPSite http://webapp.domain.com -Path C:\Backup\site_name.bak
    2. Restore the site collection to a new content database: Restore-SPSite http://webapp.domain.com/site2 -Path C:\Backup\site_name.bak -Force -DatabaseServer SQL -DatabaseName SQLDB1
    3. Move and mount database SQLDB1 on SharePoint Server 2019 farm:
      https://learn.microsoft.com/en-us/sharepoint/administration/move-content-databases

    If an Answer is helpful, please click "Accept Answer" and upvote it.
    **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. **

    1 person found this answer helpful.
    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.