Category Archives: content databases

Dismount Mount content database in sharepoint 2019 using powershell

Posted on by
Reply

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 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. 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

Source WebApplication : https://Prod-sharepointtechnicalsupport.com
Prod Content database : WSS_Content_39760_Prod
Database Server : MSSQL-PROD
Advertisements

Destination Environement UAT

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 (WSS_Content_39760_UAT_22may2020) in destination environment UAT.

You need to use the commands “Dismount-SPContentDatabase” and “Mount-SPContentDatabase” to finish the task.

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
Advertisements

Follow the video below to get detail steps.

Advertisements

content database in sharepoint

Posted on by
Reply

content database in sharepoint

A content database in sharepoint is not the database server itself but container for all the content for a single web application.

manage-content-databases-1277x640
content database in sharepoint

You can have only one content database for one web application however, you can separate content for multiple websites into multiple content databases for a site collection. You can also use a single content database for multiple site collections, keeping in mind that the site collection or collections represent a single web app.

we can run the powershell command as below to get quick details however can get from “Central Admin -> Application Management”  under “View all Site Collections”.

Get-SPContentDatabase
Get-SPContentDatabase-985x390
Get-SPContentDatabase-1898x653
Get-SPContentDatabase-1896x636

Isolation and sharing are expressed as the difference between one site collection using one database and numerous site collections sharing a database. The number of site collections using a database is also a scaling and performance issue. If you are deploying site collections with a high workload attached and greater expectancy for growth, make sure to use fewer site collections per database. You can also plan your content database strategy by adding databases to site collections as they grow or associate specific site collections only with specific content databases. The latter approach lets you isolate a database serving particular site collections from all the other databases and thus isolate the content it contains.

boundaries and limits content databases

There can be 500 content databases per farm at max. With 200GB data per content database and 100TB of data per farm. 60 million items including documents and list items. Number of site collections per content database recommended to 5,000. However, up to 10,000 site collections are supported.2500 non-Personal site collections and 7500 Personal Sites or 10000 Personal Sites alone. find in details from Microsoft Doc Link.

content database for each site collection powershell

We can run below powershell command to know which content database your site collection attached to.

$site = Get-SPSite "http://win2016:37344/sites/SPmcse"
write-host $site.WebApplication.ContentDatabases

or

$url="http://win2016:37344/sites/SPmcse"
(Get-SPSite $url).ContentDatabase.name
Get-SPContentDatabase-1920x1303
Get-SPContentDatabase-1048x480

Get SharePoint Site Content Database using Powershell | #SharePoint2019, #ContentDatabase

Get SharePoint Site Content Database using Powershell | #SharePoint2019, #ContentDatabase

Partial Index Reset of a single content source

Posted on by
Reply

Partial Index Reset of a single content source

This script will remove and re-add your content source‘s start addresses.

SharePoint will more or less rebuild the index for these sources, when the next full crawl is started.

$sourceName = "Local SharePoint sites"
$SSA = Get-SPEnterpriseSearchServiceApplication
$source = Get-SPEnterpriseSearchCrawlContentSource -Identity $sourceName -SearchApplication $SSA
$startaddresses = $source.StartAddresses | ForEach-Object { $_.OriginalString }
$source.StartAddresses.Clear()
ForEach ($address in $startaddresses ){ $source.StartAddresses.Add($address) }

Similar Post