Does a Full Text Index get replicated with the db?

Hello.When you create a full text index where does the index actually get put? Is it in the nsf file itself or is it in a file somewhere else.

When you replicate a database with a full text index does the index get replicated with it?

Many thanks in advance.

Bob

Subject: Does a Full Text Index get replicated with the db?

Its in the file system, not in the nsf, so it won’t get replicated.

OK, maybe I shouldn’t argue like that: View indices are stored within the nsf, but are still not replicated.

Subject: Does a Full Text Index get replicated with the db?

When you create a full text index where does the index actually get put? Is it in the nsf file itself or is it in a file somewhere else.

It is in a folder named like the db filename

Like Admin\mydb.nsf

the index folder will be in admin\mydb.ft

it is always a .FT

You can see it form the admin console of via the OS

When you replicate a database with a full text index does the index get replicated with it?

No.

JYR

Subject: RE: Does a Full Text Index get replicated with the db?

Many thanks guys! That’s clear now.Just one more question…

Is there a way of creating the fti on all the replicas centrally from the original database.

We have many hundreds of replicas on different servers and we don’t want to have to go into all of them individually to create the full text index.

Thanks

Subject: RE: Does a Full Text Index get replicated with the db?

Not directly, but you can check, if a FT index exists and create one if necessary through a scheduled LotusScript agent. Take care to select runs on “Any server” in the schedule for such an agent.

Subject: RE: Does a Full Text Index get replicated with the db?

If you’re creating a new replica from the client, you can select “Create full text index for searching” under the Replica Settings.

Subject: RE: Does a Full Text Index get replicated with the db?

Use the CreateFTIndex method

Usage

This method works only for local databases.

So you will have to run it under the authority of the server.

JYR

Subject: Many Thanks for your help!