The sp_text_dump_database system procedure backs up collections and (optionally) the user and text_db databases. sp_text_dump_database also maintains the text_events table by deleting entries that are no longer needed for recovery.
During a backup, the Enhanced Full-Text Search engine processes queries, but defers any update requests until the backup is complete. This eliminates the need to shut down and restart the Enhanced Full-Text Search engine.
Run sp_text_dump_database from the database containing the text indexes you are backing up. Make sure all the required servers are running when issuing sp_text_dump_database. sp_text_dump_database unconditionally backs up all indexes of all enhanced text servers. The backup of the text indexes is placed in the directory specified in the backDir configuration parameter. The output of dump database is written to the Enhanced Full-Text Search error log. Sybase recommends dumping the current database and the text_db database at the time the text indexes are backed up. However, this is optional.
For example, to back up the text indexes, the sample_colors_db database to the /work2/sybase/colorsbackup directory, and the text_db database to the /work2/sybase/textdbbackup directory, enter:
sp_text_dump_database @backupdbs = INDEXES_AND_DATABASES, @current_to = "to ’/work2/sybase/colorsbackup’", @textdb_to="to ’/work2/sybase/textdbbackkup’"
It is important that you back up the text_db database
whenever you back up text indexes, since that database contains
the metadata for all text indexes.
sp_text_dump_database may fail on Solaris if the required file size is greater than 2GB.
