Unanswered: Copying a database with text catalog to another node and instance
I have a MSSQL 2005 database that I will be adding full text searching to for one table. Weekly I copy the full backup of this database and load into another node for DR purposes. The addition of the full text catalog complicates the restore. What do I have to do to be able to bring over the FT catalog? Or is that not possible?
Should I need to enable the full text stuff on the DR database before I do the restore?
The folder names for the location of the files is different between the 2 nodes.