Copying a full-text index from 1 DB to another...

Hi everyone,
I noticed that when I did an export on a database (lets call it DB_a)
to another one (lets call it DB_b) it did not copy over the full text
index (FTI) that was on DB_a.
Is there anyway I can get the FTI from DB_a to be copied over to DB_b
without having to rebuild the FTI on DB_b'
Would appreciate any comments/hints/user-experience that you may like
to share.
Thanking you,
Al.What version of SQL Server are you using. If both servers are SQL Server
2005 then detach/attach should work fine.
almurph@.altavista.com wrote in
news:1153478984.289344.12530@.i3g2000cwc.googlegroups.com:

> I noticed that when I did an export on a database (lets call it
> DB_a)
> to another one (lets call it DB_b) it did not copy over the full text
> index (FTI) that was on DB_a.
> Is there anyway I can get the FTI from DB_a to be copied over to
> DB_b
> without having to rebuild the FTI on DB_b'
> Would appreciate any comments/hints/user-experience that you may
> like
> to share.
Ole Kristian Bangs
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging, MCTS, MCITP|||HI
For SQL 2000 you may want to look at http://support.microsoft.com/kb/240867/
and other methods and useful information about moving/copying databases may
be found at http://support.microsoft.com/kb/314546
John
"almurph@.altavista.com" wrote:

> Hi everyone,
>
> I noticed that when I did an export on a database (lets call it DB_a)
> to another one (lets call it DB_b) it did not copy over the full text
> index (FTI) that was on DB_a.
> Is there anyway I can get the FTI from DB_a to be copied over to DB_b
> without having to rebuild the FTI on DB_b'
> Would appreciate any comments/hints/user-experience that you may like
> to share.
> Thanking you,
> Al.
>