Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
Disk space is reduced significantly when you perform regular search crawls in SharePoint Server 2007
Article ID: 948909 - View products that this article applies to.
After you perform regular search crawls in Microsoft Office SharePoint Server 2007, disk space on the computer that stores the database is reduced significantly. Additionally, it may take much longer than expected to back up the search database.
This problem occurs, because the Mssbatchhistory table in the SSP Search Database is updated every time that a full crawl or an incremental crawl is performed. However, the table is not cleaned up.
To work around this problem, periodically remove all the data from the Mssbatchhistory table. To do this, follow these steps.
Warning Resetting crawled content deletes the content index and the property store. After you reset crawled content, search results will not be available until after the crawls are performed.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.