2012年3月11日星期日

Full Text Index

Hi, we are running 3 SQL server 2005 boxes with large data sets (12
million row tables). We have a full text index set up on one of them
that we would like to populate to the other servers via replication.
The question is, Can a full text index be replicated?
Thank you for your time
Yes, the full-text index statements can be replicated. You will need to
full-text enable your subscription database to begin with.
Note that the full-text catalogs themselves are not replicated, just the
creation statements are, and change tracking will ensure that your full-text
index is built and kept up-to-date on your subscriber.
http://www.zetainteractive.com - Shift Happens!
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<dstrohschein@.gmail.com> wrote in message
news:7ce48bc2-4e24-4667-ba49-2d92701b6a0d@.b1g2000pra.googlegroups.com...
> Hi, we are running 3 SQL server 2005 boxes with large data sets (12
> million row tables). We have a full text index set up on one of them
> that we would like to populate to the other servers via replication.
> The question is, Can a full text index be replicated?
> Thank you for your time

没有评论:

发表评论