Allows you to check ERSSD file locations and backup configurations, or perform an unscheduled backup of the ERSSD.
sysadmin erssd [ , backup] | [, {dbfile_dir | translog_dir | logmirror_dir}, ‘path’
Performs a single unscheduled backup of the ERSSD.
Specifies a new directory for the ERSSD database file.
Specifies a new directory for the transaction log file.
Specifies a new directory for the transaction log mirror file.
The path to the new directory.
This example shows the output of sysadmin erssd:
sysadmin erssd ---------------------
ERSSD Name ERSSD Database File ERSSD Transaction Log ERSSD Transaction Log Mirror ERSSD Backup Start Time ERSSD Backup Start Date ERSSD Backup Interval ERSSD Backup Location ---------- ------------------- --------------------- ----------------------------- ------------------------ ----------------------- ---------------------- ------------------ erssd.db /dbfile/erssd.db /log/erssd.log /backup/erssd.mlg 2am March 20, 2003 12 hours /backup
Using this command with no options displays the database file path, the transaction log path, the transaction log mirror path, and the start-time, start-date, and location of scheduled transactions.
Using this command with only the option backup performs one unscheduled backup.
Using this command with the option dbfile_dir shuts down ERSSD, moves the database to the new directory, updates the Replication Server configuration file, and restarts ERSSD, using the database from the new location.
Using this command with the option translog_dir shuts down ERSSD, moves the transaction log file to the new directory, updates the ERSSD to use the transaction log mirror in the new direcotry, updates the Replication Server configuration file, and restarts ERSSD.
Using this command with the option logmirror_dir shuts down ERSSD, moves the transaction log mirror file to the new directory, updates the ERSSD to use the transaction log mirror in the new directory, updates the Replication Server configuration file, and restarts ERSSDr
Using this command with the options dbfile_dir, translog_dir, and logmirror_dir is expensive. During this operation ERSSD is unavailable and all threads that attempt to access it fail. These threads remain blocked until ERSSD is restarted.
Use this command when you need to move files to larger, faster disks.
Use single, not double, quotation marks in the path parameter.
You must have"sa" privileges to execute this command.