怎样删除repository对应的index agent

如果你的index server还在，那当然就简单了，使用Index Agent Configuration Program就可以，但假如这个index server已经停掉了，或者你希望有其他简单的方法来删除，ok，这提供一个。

执行下边sql ：

 

 

 

 

 

 

 

select

 

 

* into dm_ftengine_config_s_bak from dm_ftengine_config_s

;

select

 

 

* into dm_ftengine_config_r_bak from dm_ftengine_config_r

;

select

 

 

* into dm_ftindex_agent_config_s_bak from dm_ftindex_agent_config_s

;

select

 

 

* into dm_fulltext_index_s_bak from dm_fulltext_index_s

;

delete

 

 

dm_ftengine_config_s

;

delete

 

 

dm_ftengine_config_r

;

delete

 

 

dm_ftindex_agent_config_s

;

delete

 

 

dm_fulltext_index_s

;