开发者

sql : How to move full text catalogue

I want to move full text catalogue for 1 database to a different location on same SQL server. I am using SQL 2005. One of the source said:

SQL Server 2005 full-text search provides the ability to easily detach and move full-text catalogs in the same way that SQL Server database files may be detached, moved, and re-attached. Full-text catalogs are included with sp_detach_db and sp_attach_db. After detaching a database, you may move the full-text catalog and/or database data files, and then re-attach the database. Full-text catalog metadata is updated to reflect the change of location. This capability simplifies building, testing, moving, and deploying databases across multiple servers.

From: http://msdn.microsoft.com/en-us/library/ms345119(SQL.90).aspx

Beleiving it, i only moved data and log file using attach and detach method, copied Full text catalog and rebuild it. Still

sp_help_fulltext_catalogs ''

shows same output with old path.

Another source: http://sqlserverpedia.com/wiki/FTS_-Restoring&_Relocating_your_Catalogs mentions Stopping and starting full text search service as a part of move. I can't restart full text service as it is being used by the other databases.

Is there any option using which I can move a single full text catalogue without restarting full t开发者_StackOverflowext service?

Regards

Manjot


I didn't have to restart service at all.. I just tried it without restarting and it worked as per: http://sqlserverpedia.com/wiki/FTS_-Restoring&_Relocating_your_Catalogs

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜