SharePoint 2013 Crawl Download File Size


If you are crawling large files in SharePoint 2013, you will see the following warning in your Search Logs.

“The file reached the maximum download limit. Check that the full text of the document can be meaningfully crawled”.  If you want to avoid this and crawl the large files you must increase this limit.

The default Download limit for crawler is 64MB.  You have to increase it to allow the crawling of videos.  Its a bit tricky decision.  I hope your videos are not Blueray DVDs converted to Mp4.  The max is 1024MB which you can set using PowerShell.  Review the video files and decide what size you must specify

$searchapp = Get-SPEnterpriseSearchServiceApplication
$searchapp.GetProperty(“MaxDownloadSize”)
#this command is just to check the current value; default is 64
$searchapp.SetProperty(“MaxDownloadSize”, <value>)
#where you replace <value> with the download limit; for example, 256

$searchapp.Update()

Now Run a Full Crawl.  Crawl might take extra time but will reduce the number of errors.

Rename Central Admin Database


If you had ran Configuration Wizard to create your SharePoint Farm then your Admin Content database will have AdminContent_XXX-XXXX-XXXXX (Guid) in its name.  If you want to fix it, so you SQL Management studio looks good and no one actually blames you to be a bad SharePoint Admin, you can use the script below.

Add-PSSnapin Microsoft.SharePoint.Powershell -ErrorAction SilentlyContinue
#List all web applications
Get-SPWebApplication -IncludeCentralAdministration

$CentralAdminUrl = "http://sp2013:2013/"
$CentralAdminDB = Get-SPContentDatabase -WebApplication $CentralAdminUrl
#Verify the database object is good
$CentralAdminDB.Name

#New DB Name
$NewCentralAdminDBName = "01_Content_NewCentralAdmin"
$NewCentralAdminContentDB = New-SPContentDatabase -Name $NewCentralAdminDBName -WebApplication $CentralAdminUrl -MaxSiteCount 2 -WarningSiteCount 1
#Verify the database is added
Get-SPContentDatabase -WebApplication $CentralAdminUrl
#Verify the database object is good 
$NewCentralAdminContentDB
#Move the Sites to nicely named DB
$CentralAdminDB.Sites | % {Move-SPSite $_ -DestinationDatabase $NewCentralAdminContentDB -Confirm:$false -Verbose}
iisreset
#Verify the Site collection are moved
Get-SPContentDatabase -WebApplication $CentralAdminUrl
#If databases are moved then dismount the orignal DB

Dismount-SPContentDatabase $CentralAdminDB -Confirm:$false -Verbose
#Confirm First Database is gone
Get-SPContentDatabase -WebApplication $CentralAdminUrl
#Delete the database from SQL Server