# move site collection to dedicate content database

- Link: https://sharepointtechnicalsupport.com/2020/08/25/move-site-collection-to-dedicate-content-database/
- Published: 2020-08-25T15:13:41+05:30
- Author: Deviprasad Panda

We have to move site collection to dedicate content database when content database
size growing too large. One content database present under a web application in 
SharePoint contains multiple site collections. We can [create or add new content databases under web application](https://sharepointtechnicalsupport.com/create-add-a-content-database-in-sharepoint-2019/)
when limit of [maximum number of sites that can be created in this database](https://sharepointtechnicalsupport.com/maximum-number-of-site-collections-per-content-database/)
exceed while [creating new site collection](https://sharepointtechnicalsupport.com/create-fast-site-collection-in-sharepoint-2019/).
If one site collection present under a content database is growing large, user request
to create a dedicate content database and move that particular site collection to
another new content database. We need to follow the steps as described below to 
move site collection to dedicate content database.

 Advertisements

 1. Get site collection GUID using powershell
 2. Get which content database site collection web application is stored
 3. Create new content database in SharePoint
 4. move site collection to different content database
 5. IISRESET SharePoint server
 6. Post Implementation testing

 Advertisements

## Get site collection GUID using powershell

Before you move site collection to another content database, get guid of sharepoint
site. You can get site collection guid using powershell script as mentioned below.

    ```wp-block-code
    $site=Get-SPSite http://win-q2repghf9du/sites/TeamSiteClassicRenamed
    $siteguid=$site.id
    echo $siteguid
    ```

![get site collection guid powershell](https://i0.wp.com/sharepointtechnicalsupport.
com/wp-content/uploads/2025/06/3ade1-get-site-collection-guid-powershell.jpg?resize
=584%2C181&ssl=1)

 Advertisements

## Get which content database site collection web application is stored

Get site collection content database details including [web application](https://sharepointtechnicalsupport.com/web-application-in-sharepoint/),
site url using the powershell command below.

    ```wp-block-code
    Get-SPSite | Where-Object {$_.Url -like "http://win-q2repghf9du/sites/TeamSiteClassicRenamed"} | select Url, ContentDatabase, WebApplication
    ```

![content database in which site collection is stored](https://i0.wp.com/sharepointtechnicalsupport.
com/wp-content/uploads/2025/06/3f585-content-database-in-which-site-collection-is-
stored.jpg?resize=584%2C100&ssl=1)

You can use the alternative command as described in my old post link below.

 [https://atomic-temporary-119393429.wpcomstaging.com/content-database-in-sharepoint/](https://atomic-temporary-119393429.wpcomstaging.com/content-database-in-sharepoint/)

 Advertisements

 Advertisements

## Create new content database in SharePoint

I described in detail about how to create or add a new content database in SharePoint
in my previous post. Follow the post linked below for more details and use the powershell
script for creating content database.

 [https://sharepointtechnicalsupport.com/create-add-a-content-database-in-sharepoint-2019/](https://sharepointtechnicalsupport.com/create-add-a-content-database-in-sharepoint-2019/)

    ```wp-block-code
    New-SPContentDatabase "WSS_Content_DB2" -DatabaseServer "WIN-Q2REPGHF9DU" -WebApplication http://win-q2repghf9du/ -MaxSiteCount 1 -WarningSiteCount 0
    ```

![Create new content database in sharepoint using powershell](https://i0.wp.com/
sharepointtechnicalsupport.com/wp-content/uploads/2025/06/85a25-create-new-content-
database-in-sharepoint-using-powershell.jpg?resize=584%2C135&ssl=1)

 Advertisements

 Advertisements

![Content database in sql server](https://i0.wp.com/sharepointtechnicalsupport.com/
wp-content/uploads/2025/06/139cc-content-database-in-sql-server.jpg?resize=584%2C752&
ssl=1)

 Advertisements

## move site collection to different content database

Now we are ready to move site collections between databases using the powershell
command [Move-SPSite](https://docs.microsoft.com/en-us/powershell/module/sharepoint-server/move-spsite?view=sharepoint-ps)
as described below.

    ```wp-block-code
    Move-SPSite "http://win-q2repghf9du/sites/TeamSiteClassicRenamed" -DestinationDatabase "WSS_Content_DB2"
    ```

![move site collection to dedicate content database](https://i0.wp.com/sharepointtechnicalsupport.
com/wp-content/uploads/2025/06/238a5-move-site-collection-to-dedicate-content-database.
jpg?resize=584%2C134&ssl=1)

 Advertisements

 Advertisements

## IISRESET SharePoint server

You will get a message in powershell window like “IIS must be restarted before this
change will take effect. To restart IIS, open a command prompt window and type iisreset”.
You have to do IIS reset SharePoint server.

    ```wp-block-code
    iisreset
    ```

![iisreset sharepoint server](https://i0.wp.com/sharepointtechnicalsupport.com/wp-
content/uploads/2025/06/b30f6-iisreset.jpg?resize=584%2C297&ssl=1)

 Advertisements

 Advertisements

## Post Implementation testing

After move site collection to new content database completed, you can check GUID
of the site collection again. Its same as source location.

![check guid of site in sharepoint](https://i0.wp.com/sharepointtechnicalsupport.
com/wp-content/uploads/2025/06/8b7b9-check-guid-of-site-in-sharepoint.jpg?resize
=584%2C186&ssl=1)

check content database of site collection to cross check the new content database
as destination location.

![check content database of site collection](https://i0.wp.com/sharepointtechnicalsupport.
com/wp-content/uploads/2025/06/e97ec-check-content-database-of-site-collection.jpg?
resize=584%2C119&ssl=1)

 Advertisements

 Advertisements

 Advertisements

 * [create add a content database in sharepoint 2019⌊create content database add a content database to web application using powershell sharepoint 2019⌉](https://sharepointtechnicalsupport.com/2020/07/22/create-add-a-content-database-in-sharepoint-2019/)
   Date22/07/2020
 * [Dismount Mount content database in sharepoint 2019 using powershell⌊Dismount Mount content database in sharepoint 2019 using powershell⌉](https://sharepointtechnicalsupport.com/2020/05/26/dismount-mount-content-database-in-sharepoint-2019-using-powershell/)
   Date26/05/2020
 * [content database in sharepoint⌊sharepoint-content-database-1920x1080⌉](https://sharepointtechnicalsupport.com/2018/10/18/content-database-in-sharepoint/)
   Date18/10/2018

 Advertisements

### Share this:

 * [  X ](https://sharepointtechnicalsupport.com/2020/08/25/move-site-collection-to-dedicate-content-database/?share=twitter)
 * [  Facebook ](https://sharepointtechnicalsupport.com/2020/08/25/move-site-collection-to-dedicate-content-database/?share=facebook)
 * [  WhatsApp ](https://sharepointtechnicalsupport.com/2020/08/25/move-site-collection-to-dedicate-content-database/?share=jetpack-whatsapp)
 * [  Email ](https://sharepointtechnicalsupport.com/2020/08/25/move-site-collection-to-dedicate-content-database/?subject=%5BShared%20Post%5D%20move%20site%20collection%20to%20dedicate%20content%20database&body=https%3A%2F%2Fsharepointtechnicalsupport.com%2F2020%2F08%2F25%2Fmove-site-collection-to-dedicate-content-database%2F&share=email)
 * [  Telegram ](https://sharepointtechnicalsupport.com/2020/08/25/move-site-collection-to-dedicate-content-database/?share=telegram)
 * [  LinkedIn ](https://sharepointtechnicalsupport.com/2020/08/25/move-site-collection-to-dedicate-content-database/?share=linkedin)
 * [  Tumblr ](https://sharepointtechnicalsupport.com/2020/08/25/move-site-collection-to-dedicate-content-database/?share=tumblr)
 * [  Pinterest ](https://sharepointtechnicalsupport.com/2020/08/25/move-site-collection-to-dedicate-content-database/?share=pinterest)

### Like this:

Like Loading…