(Enhanced version only)
Restores a text index backup.
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 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.
See references to the configuration paramter restoreCmd for customizing backups.
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.