November 29, 2005 at 3:36 pm
I have a 9-million record table that can take too long to populate a full-text index. Is it possible to full-text index it in a separate SQL Server server (previously copying the table over, I presume) and somehow backup/restore or copy or someway to move the populated full-text index to be used with the original table? The idea is to avoid the use of the orignal server to run a resource-counsuming process of building a full-text index.
Thanks,
Geek Tutor
November 29, 2005 at 4:06 pm
I haven't gotten the full-text indexes successfully moved from one server to another. I understand from Quest that SQLTurbo will help with this, but I haven't tried it yet. There is also a knowledgebase article you can investigate.
1. http://www.quest.com/sql_turbo/index.asp
2. Follow this knowledgebase article: http://support.microsoft.com/default.aspx?scid=kb;en-us;240867
Michelle
December 1, 2005 at 12:14 pm
Thanks mimorr.
Article http://support.microsoft.com/default.aspx?scid=kb;en-us;240867 really answers my question. It is complicated and a little risky, but it could work.
Geek Tutor
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply