Appendix A: System Procedures

sp_text_load_index

Restores a text index backup.

sp_text_load_index

sp_text_load_index

Restores all text indexes in the current database.

Run sp_text_load_index after the text_db database and the current database have been fully recovered.
sp_text_load_index restores the Verity collections from the most recent backup. The Enhanced Full-Text Search engine then runs sp_redo_text_events and sp_text_notify to reapply all entries in the text_events table since the date and time the index was backed up.

Server name ‘server_name’ does not exist in sysservers.
Unable to restore text indexes for server ‘server_name.’
This procedure is not supported against remote server ‘server_name’
Update to text_events table in database database_name failed for server ‘server_name’ –text_events not rolled forward.

Any user can execute sp_text_load_index.