Show TOC

sysadmin restore_dsi_saved_segmentsLocate this document in the navigation structure

Restores backlogged transactions.

Syntax
sysadmin restore_dsi_saved_segments, <data_server>, <database>
Parameters
data_server

The name of the data server.

database

The name of the database.

Examples
Example 1

Restores backlogged transactions for the <pubs2> database in the TOKYO_DS data server:

sysadmin restore_dsi_saved_segments, TOKYO_DS, pubs2
Usage
  • The DSI must be explicitly suspended before you can use this command to restore saved segments.

  • Any backlogged transactions saved because a save interval was specified for the connection (using alter connection) are candidates for restoring into the database. The Replication Server uses rs_get_lastcommit to decide which transactions to filter.

Permissions

sysadmin restore_dsi_saved_segments requires “sa” permission.