I'm wondering how to move just a full-text catalog (along with its table) from one SQL 2005 database to another SQL 2005 server.
We have a table with 10 million rows, and the data will be updated weekly. The full-text catalog ususally takes many hours to build. Since the production database must be available 24x7, I would like to know whether we can build the full-text catalog in our staging server, and move / copy the catalog to the production server. This would avoid building a full-text catalog in the production server directly. The table itself will be DTS over before hand, so there is no difference in table structure or data.
Does anyone know how to achieve this? I have a Microsoft article talking about SQL 2000 (but not 2005). http://support.microsoft.com/kb/240867#appliesto I'm not sure whether it can be done via backup and restore without invloving the mdf file. Hope someone can give me a step by step guide. Thanks.
Larry