SQL 2000 SP 3a running in an active passive cluster on Windows 2003.
This is the publisher and distributor of several publication in
transaction replication. Subscriptions are pulled anonymously. I plan
on setting up Full Text indexes/search on the cluster, on several of
the replicated tables, and was wondering if anyone has had any
experiences with this or can find any reason it would not work. Since
it's SQL 2000 and timestamp values can be replicated I can't see that
this would be an issue (as with SQL 7) as I will be using Change
Tracking to keep the indexes up to date.
I'm not necessarily concerned about replicating the full text indexes,
although it may be of use later. My major concern is can I replicate
the tables that have full text indexes with out issue? Also, since the
tables are already published can I just add the full text indexes
without worry?
Charlie
Hi Charlie,
Sorry for the late response.
[vbcol=seagreen]
Yes, you could make the replication for a Replicated database/table
successfully.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
Monday, March 12, 2012
Replication and Full Text Indexes.
Labels:
active,
cluster,
database,
distributor,
indexes,
intransaction,
microsoft,
mysql,
oracle,
passive,
publication,
publisher,
replication,
running,
server,
sql,
text,
windows
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment