Moving FTDATA folder

Question

Post reply

Moving FTDATA folder

Renuka__

Hall of Fame

Points: 3656
More actions
July 7, 2010 at 5:00 am

#141854

Hi,
Could anyone please let me know how to move FTDATA folder from one drive to another. There are noisexxx.txt files and tsxxx.xml files ( which I think, are installation files) under this folder. I have tried it on Google but could not find much information ( all the articles are directing me on moving Catalog files, but not these files under FTDATA folder). I have found few registry keys under which this path can be changed, but I am not sure at all, if that is correct approach.
This is a production server and downtime can be arranged.
Any help would be much appreciated. Thank you in advance.
Renuka__
[font="Verdana"]Renuka__[/font]

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

free_mascot One Orange Chip Points: 27169 More actions · Answer 1

check this...

http://support.microsoft.com/kb/240867#appliesto

HTH

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

Renuka__ Hall of Fame Points: 3656 More actions · Answer 2

Thank you for your response.

I did check that article earlier; but it does not say it is applicable for SQL 2005.

[font="Verdana"]Renuka__[/font]

Toby Miller Valued Member Points: 71 More actions · Answer 3

Hello, Did you find any answers to your question? I would really like to move the entire FTDATA folder and all its content to a new directory.

Thanks in advance.

Renuka__ Hall of Fame Points: 3656 More actions · Answer 4

Hi,

It was done succesfully.

Stopped the FT services. Copied the FTDATA contents over to new drive from existing drive. Deatched the database and attached it back by specifying new FTDATA location for FT Catalogues.

Registry changes for default FT path and noisexxx.txt and tsxxx.xml files:

Default path:

FullTextDefaultPath --HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer

Seperate keys for each language, so we had to change about 17 keys here:

NoiseFiles -- HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSearch\Language -- seperate keys for each language.

Seperate keys for each language, so we had to change about 17 keys here:

TsaurusFiles -HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSearch\Language\ -- seperate keys for each language.

Restarted the FT service.

Make sure that the FT catalogues are online; (query sys.database_files under teh same database) because there is a possibility that they go offline. We had few files offline and we rebuilt them and they came up OK.

Hope this information helps.

Thank you

[font="Verdana"]Renuka__[/font]