sp_text_dump_database

Description

Makes a backup copy of a text index.

Syntax

sp_text_dump_database backupdbs [, current_to] [, 
     current_with] [, current_stripe01 [, ... [, 
     current_stripe31]]] [, textdb_to] [, textdb_with] [, 
     textdb_stripe01 [, ... [, textdb_stripe31]]]

Parameters

backupdbs

specifies whether the current database and the text_db database are backed up before the text index is backed up. Valid values are shown in Table A-3.

Table A-3: Values for backupdbs

Value

Description

CURRENT_DB_AND_INDEXES

Indicates that the current database is backed up before the text indexes are backed up.

CURRENT_DB_AND_CURRENT_INDEXES

Indicates that the current database is backed up before the text indexes are backed up, and only the indexes associated with the current database are dumped.

TEXT_DB_AND_INDEXES

Indicates that the text_db database is backed up before the text indexes are backed up.

INDEXES_AND_DATABASES

Indicates that the current and text_db databases are backed up before the text indexes are backed up.

ONLY_INDEXES

Indicates that only the text indexes are backed up.

current_to

is the to clause of the dump database command for dumping the current database. Use this only if you specify CURRENT_DB_AND_INDEXES or INDEXES_AND_DATABASES for the backupdbs parameter.

current_with

is the with clause of the dump database command for dumping the current database. Use this only if you specify CURRENT_DB_AND_INDEXES or INDEXES_AND_DATABASES for the backupdbs parameter.

current_stripe

is the stripe clause of the dump database command for dumping the current database. Use this only if you specify CURRENT_DB_AND_INDEXES or INDEXES_AND_DATABASES for the backupdbs parameter.

textdb_to

is the to clause of the dump database command for dumping the text_db database. Use this only if you specify INDEXES_AND_DATABASES for the backupdbs parameter. Use this only if you specify TEXT_DB_AND_INDEXES or INDEXES_AND_DATABASES for the backupdbs parameter.

textdb_with

is the with clause of the dump database command for dumping the text_db database. Use this only if you specify TEXT_DB_AND_INDEXES or INDEXES_AND_DATABASES for the backupdbs parameter.

textdb_stripe

is the stripe clause of the dump database command for dumping the text_db database. Use this only if you specify TEXT_DB_AND_INDEXES or INDEXES_AND_DATABASES for the backupdbs parameter.

Examples

Example 1

sp_text_dump_database ONLY_INDEXES

Only text indexes are backed up.

Example 2

sp_text_dump_database CURRENT_DB_AND_INDEXES, "to ’/data/db1backup’"

The current database is dumped to /data/db1backup before the text indexes are backed up.

Example 3

sp_text_dump_database @backkupdbs = "TEXT_DB_AND_INDEXES", @textdb_to = "to ’/data/textdbbackup’"

The text_db database is dumped to /data/textdbbackup before the text indexes are backed up.

Example 4

sp_text_dump_database @backupdbs = "INDEXES_AND_DATABASES", @current_to = "to ’/data/db1backup’", 
@textdb_to = "to ’/data/textdbbackup’"

The current database is dumped to /data/db1backup and the text_db database is dumped to /data/textdbbackup before the text indexes are backed up.

Usage

Messages

.

Permissions

Any user can execute sp_text_dump_database.

See also

dump_database in the Reference Manual.