A useful script for running on your dev\\uat environments to free valuable disk space. The crawl store database can grow quite significantly over time.<\/p>\n
First of all, the PowerShell script:<\/p>\n
\r\n# Load the SharePoint assembly - change the version to 15.0.0.0 for SharePoint 2013\r\nAdd-Type -AssemblyName \"Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c\"\r\n\r\n# Reset the content index\r\n(Get-SPEnterpriseSearchServiceApplication).Reset($true,$true)\r\n\r\n# Get the database server for the default content service\r\n$dbServer = [Microsoft.SharePoint.Administration.SPWebService]::ContentService.DefaultDatabaseInstance.NormalizedDataSource\r\n\r\n# Get the SQL Management Object server for the content service retrieved above\r\n[System.Reflection.Assembly]::LoadWithPartialName(\"Microsoft.SqlServer.SMO\") | out-null\r\n$SMOserver = New-Object ('Microsoft.SqlServer.Management.Smo.Server') -argumentlist $dbServer\r\n\r\n# Get the search service application instance\r\n$searchServiceApp = (Get-SPEnterpriseSearchServiceApplication)\r\n\r\n# Iterate the crawl stores and for each database, shrink it in size by 20%\r\nforeach($crawlStore in $searchServiceApp.CrawlStores)\r\n{\t\t\r\n\t$dbName = $crawlStore.Name\t\r\n\t$db = $SMOserver.Databases[$dbName]\r\n\tif ($db -ne $null) \r\n\t { \r\n\t\t$db.Shrink(20, [Microsoft.SqlServer.Management.Smo.ShrinkMethod]'TruncateOnly')\r\n\t\tWrite-Host \"$dbName has been shrunk\"\r\n\t }\r\n\t else\r\n\t {\r\n\t\tWrite-Host \"$dbName does not exist\"\r\n\t }\r\n}\r\n<\/pre>\nComments in the script should make this one clear to understand, happy coding!<\/p>\n","protected":false},"excerpt":{"rendered":"
A useful script for running on your dev\\uat environments to free valuable disk space. The crawl store database can grow quite significantly over time. First of all, the PowerShell script: # Load the SharePoint assembly – change the version to … Continue reading