Sometimes the Indexing generates an unsual big size mdf file for the search database. If you have disk space shortage this article might help you.
Once you reset the all cralled content in the Shared Services > Search Settings, if the Search DB is too large and you have disk space issue sin your DB server you must do the following:
1. Go to Shared Services > Search
2. Go to Content Sources and crawll schedules.
3. Stop all search crawls.
Note: Stopping the search crawlls usually generates big LOG files that can clog your DB server if it is already struggling with lack of space.
4. Reset all crawlled content (Shared Services > Search Settings)
3. Go to the DB server and open SQL 2005.
4. Now the search DB must be shrunk:
5. Right click the search DB go to All Tasks > Shrink > Database, follow the image below (you must check "reorganize files..."):
6. Right click the search DB go to All Tasks > Shrink > Files, with default settings:
7. This should be enough to release space from your DB server. Good luck! :)


No comments:
Post a Comment