Moving your FTData files and FDLAUNCHERRORLOG in Clustered SQL Server 2008

Scenario: I have given a new storage by SAN team to move my database files and logs from old drive to the new storage. All database files and logs files have been successfully migrated to the new storage. But how do you move your files for your FullText Daemon Launcher (FTData Folder and FDLAUNCHERRORLOG) service.

Solution: All this is done via modifying values in the registry editor. But before you do this, you need to test this solution in a staging or test server before moving on to your production environment. Also since this involves modifying registry values, it is necessary to take extra precautions when making changes. I always have the old values saved to a location somewhere in case something goes wrong with my changes.

Stop your SQL full-text filter daemon launcher service from SQL Server Configuration Manager.

To change the location of the FTData folder, go to the following location.

“HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL10.<INSTANCEID>\Setup\FullTextDefaultPath”

Modify this value with the new location that you have.

Start your SQL full-text filter daemon launcher service from SQL Server Configuration Manager.

“SQL Server Fulltext Filter Daemon Launcher” service will be up and running even though the FDLAUNCHERRORLOG is not getting generated. For this log file, you may save it your default Server Log folder and grant necessary permissions to the folder.

Then you can test failing over your cluster to verify that everything is in place.

About these ads

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

The SQL Pro

(Ayman El-Ghazali - www.thesqlpro.com)

Meels on Wheels

Meels for breakfast, lunch and dinner.

juliansherman

Just another WordPress.com site

Paul Turley's SQL Server BI Blog

from the world of Microsoft SQL Server BI and reporting

TroubleshootingSQL

Explaining the bits and bytes of SQL Server

Coding Tips

We will improve your knowledge

SQL Studies

My SQL Studies

It's Hemlock Time

We don't make sense. It's innate.

Sql And Me

My Experiments with SQLServer

Dimitrios Kalemis

I am exactly like Jesus Christ: an atheist and anarchist against society and bad people with influence and power (judges, social workers, politicians, priests, and teachers).

Clint Huijbers' Blog

Microsoft BI consultant

Blog of Many Useless Wonders

Where Uselessness Abounds!

Stevespevack's Blog

IT Recruitment

SQL Problems and Solutions

Sharing the knowledge & experience of SQL, DBA & BI

Glenn Berry's SQL Server Performance

Semi-random musings about SQL Server performance

Algonquin Studios Blog

Ideas and opinions on software development, web design, customer service, sales and marketing...and food

SutoCom Solutions

Success & Satisfaction with the Cloud

Terli Srinivasa rao Blog

Sql server and Tableau practices

AccessAdp.com

SQL Server Architect | MCTIP: Database Administrator | Microsoft Office | Hadoop

Follow

Get every new post delivered to your Inbox.

Join 46 other followers

%d bloggers like this: