Microsoft KB Archive/817296

= INF: Change the Location of Temporary Files for Full-Text Searches =

Article ID: 817296

Article Last Modified on 6/13/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows Registry



SUMMARY
This article describes how to change the location of the temporary files that are used during full-text searches of binary large objects (BLOBs).



MORE INFORMATION
By default, the Microsoft Search service uses the default full-text path for temporary storage when a full-text index is created on an image column. Depending on the type of file (.doc, .htm, and other file types) and the size of the file that is stored in the image column, the temporary files may experience heavy use. This use causes high I/O activity and space use. Because the system does not typically have the I/O throughput of a RAID array, move the temporary storage location to a RAID 0 disk array. Additionally, if possible, keep that location separate from the storage location of your full-text catalogs.

In a default installation of SQL Server 2000, the default full-text path is Program Files\Microsoft SQL Server\Mssql\Ftdata. This path is used as both the location of temporary files that are used when BLOB data is indexed and the default root path where new full-text catalogs are created. You can change this path by editing the following registry key:

Default instance:

Named instance:

WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.

On Microsoft Windows 2000 Server-based computer running Windows Clustering, the temporary folder must be on a local disk on each node. Additionally, you must not set the path of the temporary files to the same location as the page files of the server (Pagefile.sys). A script named Settemppath.vbs was previously used to change this location. However, Settemppath.vbs does not affect the temporary location for SQL Server 2000 full-text temporary files, but it may affect the temporary location for other products that use the Microsoft Search service.

Keywords: kbinfo KB817296

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.