Step 1
First, take a content database backup from old server.
Please follow the steps below.
- Go to the central admin and click on “Manage Content Databases”.
2. Select the web application for which you need the content database backup.
3. Copy the Content Database name. Then select the Content Database.
4. Open the SQL server management studio. Expand the database and Select the database. Right-click on it. Select the Tasks > Back Up.
5. It will navigate to the following window. Select the below location.
6. Remove this path and add the path where you want to save your back up (.bak) file.
7. Now, click on the OK button and wait till the backup completes successfully.
8. Once complete you can see your .bak file in the location which you have set above.
Step 2
Create a new web application on the SP 2019 environment. To create a new web application go to central admin and clicks on “Manage web application”.
And now, click the “New” ribbon button.
A dialog will appear. Please enter all the necessary information.
Now, Wait until the processing is finished.
Finally, you can see your new web application has been successfully created on your end.
After creating the web application follow these steps as mentioned below.
- Select Application Management and Select the Manage Content Database under the Databases.
- Select the web application you have created.
- Then click on the Content Database name (copy the name of the database to use it later on), it will take you to the Manage Content Database Settings page.
Under the Database Status, select the “Offline” option from the dropdown list.Check the Check Mark in the “Remove content database” checkbox.
A prompt will come, select OK on that. Now the content database is removed from the web application.
- To detach the Content Database from SQL Server Management Studio please follow the steps: Connect the SQL Server Management Studio => Expand the Database. => Select the content database name that you have copied previously=>Right click on SQL => Tasks= > Detach
Check the checkbox in the Drop and click Ok.
Step 3
Restore the old database.
- Right Click on Database and select Restore.
- Now select the “Device” radio button and browse the path where you have kept the old backup file
- Select the file from the folder. Now you can see a similar window as shown below. Please verify the things and then click on the “Ok” button.
- Select the file from the folder. Now you can see a similar window as shown below. Please verify the things and then click on the “Ok” button.
Please wait for it to successfully restore the database on your new server SQL Server environment.
Step 4
Now, the time has come to associate and upgrade this content database to newly created web application. Please use this below command to mount the database to a new web application.
Open the new SharePoint Management Shell as “Run as Administrator”.
Mount-SPContentDatabase “<DatabaseName>” -DatabaseServer “<Db server name>” –WebApplication “<webapplication url>”
Once the command executes successfully, then you will get a message, as shown below. This command will upgrade the database and attach this content database to the web application.
