Full text catalog - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Full text catalog

Author

Topic

monty
Posting Yak Master

130 Posts

Posted - 2008-07-22 : 13:57:40

Gurus,

we are migrating some of the databases from server A(sql 2000) to server B(sql 2005). Now my question is i have a database which has full text indexes on sql 2000, i am using attach-detach for the migration.. Do i neeed to pay any special attention for this database.. or any of you have a better procedure for the above requirement based on your earlier implementaions...

also i am aware of scrpting the full text indexes dropping them at source attaching the db at destination and running back the script..

all your suggestions are welcomed!!

thanks in advance

its me monty

monty
Posting Yak Master

130 Posts

Posted - 2008-07-22 : 17:30:37

does any one have any suggestion? or is my query unclear?

its me monty

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2008-07-22 : 20:42:20

I think you need to rebuild the catalogs..
http://msdn.microsoft.com/en-us/library/ms142490.aspx

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-22 : 23:03:09

Agree since attaching db will not move index catalog files to sql2k5 server.

monty
Posting Yak Master

130 Posts

Posted - 2008-07-23 : 14:21:15

Thanks Dinakar\Rmiao,

would you mind in elaborating it further as i have little knowledge with full text catalogs

its me monty

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-23 : 23:42:22

You have to reconfigure full text index after moving sql2k db to sql2k5 with detach/attach.