# Dismount Mount content database in sharepoint 2019 using powershell

- Link: https://sharepointtechnicalsupport.com/2020/05/26/dismount-mount-content-database-in-sharepoint-2019-using-powershell/
- Published: 2020-05-26T14:35:14+05:30
- Author: Deviprasad Panda

As a sharepoint administrator you must be facing regular tasks to Dismount Mount
content database in sharepoint 2019 using powershell. This is most common and frequest
task everyone faces.

User requests to restore content database from sharepoint production environment
for a particular date and time in UAT environment. In this case we use this content
database back up and restore method by help of sql server team. After back and restore
completed by sql team, as a sharepoint administrator we need to dismount the content
database from [web application](https://sharepointtechnicalsupport.com/web-application-in-sharepoint/)
and mount content database to web application at the destination location UAT.

 Advertisements

How to mount content database in sharepoint web application, attach content database,
dismount content database, detach content database, backup content database and 
restore to another content database, move site collection from one site collection
to another site collection, content database upgrade from one sharepoint version
to another sharepoint version, migrate site collection, back up site in sharepoint
and restore in another sharepoint environment, [move site collection](https://sharepointtechnicalsupport.com/move-site-collection-to-dedicate-content-database/).
All these questions have these below activity as solution.

Request SQL database team to back up and restore with details as below.

 Advertisements

### Source Environment Production

    ```wp-block-code
    Source WebApplication : https://Prod-sharepointtechnicalsupport.com
    Prod Content database : WSS_Content_39760_Prod
    Database Server : MSSQL-PROD
    ```

 Advertisements

### Destination Environement UAT

    ```wp-block-code
    Destination WebApplication : https://UAT-sharepointtechnicalsupport.com
    UAT Content database : WSS_Content_39760_UAT_22may2020   # This will be the name of restored Db
    Database Server : MSSQL-UAT
    Permission : Permissin maping WSS_Content_46298_2Jan2020 present in same server MSSQL-UAT and farm account "Administrator" should have admin permission in the content database.
    ```

 Advertisements

As a sharepoint administrator, you need to dismount (Previously there must be some
content Db attached in the UAT site for example: WSS_Content_46298_2Jan2020) and
mount the restored [content database](https://sharepointtechnicalsupport.com/content-database-in-sharepoint/)(
WSS_Content_39760_UAT_22may2020) in destination environment UAT.

You need to use the commands “[Dismount-SPContentDatabase](https://docs.microsoft.com/en-us/powershell/module/sharepoint-server/dismount-spcontentdatabase?view=sharepoint-ps)”
and “[Mount-SPContentDatabase](https://docs.microsoft.com/en-us/powershell/module/sharepoint-server/mount-spcontentdatabase?view=sharepoint-ps)”
to finish the task.

    ```wp-block-code
    Dismount-SPContentDatabase WSS_Content_46298_2Jan2020
    Mount-SPContentDatabase "WSS_Content_39760_UAT_22may2020" -DatabaseServer "MSSQL-UAT" -WebApplication https://UAT-sharepointtechnicalsupport.com
    ```

![Dismount Mount content database in sharepoint 2019](https://i0.wp.com/sharepointtechnicalsupport.
com/wp-content/uploads/2025/06/48ab6-dismount-mount-content-database-in-sharepoint-
2019.jpg?resize=584%2C295&ssl=1)

 Advertisements

Follow the video below to get detail steps.

 Advertisements

### Share this:

 * [  X ](https://sharepointtechnicalsupport.com/2020/05/26/dismount-mount-content-database-in-sharepoint-2019-using-powershell/?share=twitter)
 * [  Facebook ](https://sharepointtechnicalsupport.com/2020/05/26/dismount-mount-content-database-in-sharepoint-2019-using-powershell/?share=facebook)
 * [  WhatsApp ](https://sharepointtechnicalsupport.com/2020/05/26/dismount-mount-content-database-in-sharepoint-2019-using-powershell/?share=jetpack-whatsapp)
 * [  Email ](https://sharepointtechnicalsupport.com/2020/05/26/dismount-mount-content-database-in-sharepoint-2019-using-powershell/?subject=%5BShared%20Post%5D%20Dismount%20Mount%20content%20database%20in%20sharepoint%202019%20using%20powershell&body=https%3A%2F%2Fsharepointtechnicalsupport.com%2F2020%2F05%2F26%2Fdismount-mount-content-database-in-sharepoint-2019-using-powershell%2F&share=email)
 * [  Telegram ](https://sharepointtechnicalsupport.com/2020/05/26/dismount-mount-content-database-in-sharepoint-2019-using-powershell/?share=telegram)
 * [  LinkedIn ](https://sharepointtechnicalsupport.com/2020/05/26/dismount-mount-content-database-in-sharepoint-2019-using-powershell/?share=linkedin)
 * [  Tumblr ](https://sharepointtechnicalsupport.com/2020/05/26/dismount-mount-content-database-in-sharepoint-2019-using-powershell/?share=tumblr)
 * [  Pinterest ](https://sharepointtechnicalsupport.com/2020/05/26/dismount-mount-content-database-in-sharepoint-2019-using-powershell/?share=pinterest)

### Like this:

Like Loading…

### _Related_