Morning,
Here is my scenario:
I have a SQL Server 2000 server with 10 clients.
Each client has 5 Full-Text Catalogs. For ease of explanation let’s call the FTCs C1 thru C5.
Now each client’s FTCs are named the SAME. So each client has FTCs named C1, C2, C3, C4 and C5.
I need to move the clients to our new SQL Server 2005 Enterprise server.
I can backup up the DB using the native SQL Server 2000 backup command but that of course does not back up the FTCs.
So once I restore the client DB over to the new SS2K5 server, how do I re-enable the FTCs and rebuild them so that they are the same as what was over on the SS2K server.
Also, after the first client is complete, will I run into a duplicate FTC error when I try to recreate the subsequent clients on the server since they all have the same named FTCs?
If so, how do I overcome this event?
Thanks for any and all help!
JJKusch,
In SQL Server 2005, the format of full-text catalogs has changed significantly. This change requires all full-text catalogs from previous versions of SQL Server to be rebuilt.
