Previous Setup Drive Shares Manual Install Setup SQL Folder Structure Next

Setup No Drive Indexing

FineBuild can disable indexing of drive contents.

The indexing of drive contents can speed up the process of finding a file. However, it is very rare that files will need to be searched on a database server, and the processing time taken by Windows to maintain the drive index would be better used to process end-user database queries.

It is therefore recommended that drive contents indexing is disabled for database servers.

FineBuild No Drive Indexing Processing

Processing of No Drive Indexing relates to Process Id 1FA in the FineBuild1Preparation script, and is controlled by the parameter below:

Parameter Build SQL2005 SQL2008 SQL2008 R2 SQL2012 SQL2014
SetupNoDriveIndex FULL Yes Yes Yes Yes Yes
SetupNoDriveIndex WORKSTATION No No No No No
SetupNoDriveIndex CLIENT No No No No No

SQL FineBuild will start a CMD window to apply the attribute changes needed to disable drive indexing. This process may take a few minutes to complete. If you open the CMD window you will see each file name as it is processed, and some files may not have their index attribute changed due to lack of permissions. This behaviour is normal, and the disable drive indexing process will eventually complete.
Top

Manual Setup No Drive Indexing Processing

The following steps show what you would have to do to setup No Drive Indexing manually. FineBuild does all of this work for you automatically.

1) Right-click on each drive letter and select Properties

2) Unless you are installing Express Edition, clear the checkbox Allow Indexing Service… and click on Apply.
SetNoIndex.png
3) Click on OK to confirm disabling content indexing.
Confirm.png
4) If you get a message similar to that shown below, click Ignore All.
AttrError.png
Copyright © 2014 Edward Vassie. License and Acknowledgements
Previous Setup Drive Shares Top Setup SQL Folder Structure Next

Last edited Oct 8, 2014 at 10:14 AM by EdVassie, version 5