Manage the Embedded Replication Server System Database

Replication Server can run on either an Adaptive Server Enterprise Replication Server System Database (RSSD) or on an Embedded RSSD (ERSSD). ERSSDs are designed for users who do not want to use Adaptive Server Enterprise to manage the Replication Server RSSD.

Replication Server is easy to install and manage with ERSSD. ERSSD is automatically installed, configured, and started in the background if you specify that you want to use it. Backup procedures are automatic and preconfigured.

Remember: You cannot migrate from ERSSD to RSSD. To use ERSSD, you must select it when you install Replication Server. See the Replication Server Installation Guide.

Sybase provides ERSSD as an option in Replication Server, implemented in SQL Anywhere. Sybase continues to support the traditional RSSD, implemented in Adaptive Server Enterprise. All the ERSSD features discussed pertain to ERSSD only; they do not affect the behavior of the traditional RSSD in Adaptive Server Enterprise.

ERSSD runs on three operating system files:

A database root file
A transaction log file
A transaction log mirror file

When you start rs_init, provide the directories for these files, and make sure that the name of your ERSSD is in the interfaces file.

Tip: For better performance and better protection against disk failure, put each one of these files on a different physical device.

Obtain Information on ERSSD Settings
Learn how to obtain configuration settings and other information on ERSSD.
ERSSD Configuration Parameters and Command
Use the ERSSD configuration parameters to configure backup time and backup directory, and ERSSD routing.
Backup ERSSD
An automatic full backup, including both the database file and the transactional log file, is performed at the default or the configured time. You can perform an unscheduled backup for ERSSD.
ERSSD Routing
Use create route to create a route from Replication Server with ERSSD.
Move ERSSD Files
Use sysadmin erssd to move the ERSSD database file, transaction log, or transaction log mirror.
ERSSD User Administration
You can change ERSSD user paswords, add users, and assign permissions.
Reduce ERSSD File Size
Use sysadmin erssd with the defrag parameter to recover any unused space, shrink the ERSSD size, and rebuild the ERSSD database file.
ERSSD Recovery Procedures
ERSSD automatically manages recovery from operating system crashes, database server crashes, and crashes caused by shutting down improperly. You can use several procedures designed for recover a database damaged by media failure and ensure a clean recovery after media failure.

Parent topic: Manage a Replication System