Is there any way to move a db with full-text indexes from one physical machine to another without having to drop catalog/indexes and the re-create them?
Cheers!
/Eskil
Hi,
From your description, it seems that you want to move a database with full indexes, right?
Full-text catalogs and indexes are not stored in a SQL Server database. Full-text catalogs and indexes are stored in separate files that the Microsoft Search service manages. You cannot use the Transact SQL statements BACKUP and RESTORE to back up and to restore full-text catalog files. After recovery or restore operations, you must separately resynchronize the full-text catalogs.
You may refer the following link which shares some solutions to move, copy, and back up full-text catalog folders and files.
http://support.microsoft.com/kb/240867
Hope it helps. Thanks.
That article mate it utterly clear that I will just save my index creation statements in my snippets collection...
Thanks for helping out!
/Eskil
No comments:
Post a Comment