How can I rename full text indexing file name

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mbhsye - 04 Jun 2008 20:03 GMT

Can any one point me to right direction for renaming of full text
index file name. I have full text indexing on a table and I have to
rename this file without droping and receating full text indexing. For
example
SELECT name, physical_name
FROM sys.master_files
WHERE database_id = DB_ID('adventureworks');

gives me

sysft_AdvWksFtCat C:\myFTCatalogs\AdvWksFtCat1
and I want to rename sysft_AdvWksFtCat name to AdvWksFtCat_Servername
Thanks in advance.

Reply to this Message

Russell Fields - 05 Jun 2008 15:43 GMT

I don't believe that you can rename the catalog. (I do know that if you
restore the database you can rename the folder at the time of restore, but
that is not what you want.)

RLF

> Can any one point me to right direction for renaming of full text
> index file name. I have full text indexing on a table and I have to
[quoted text clipped - 9 lines]
> and I want to rename sysft_AdvWksFtCat name to AdvWksFtCat_Servername
> Thanks in advance.

Reply to this Message