sysadmin erssd

Description

Allows you to check ERSSD file locations and backup configurations, or perform an unscheduled backup of the ERSSD.

Syntax

sysadmin erssd [ , backup] | [, {dbfile_dir | translog_dir | logmirror_dir}, ‘path

Parameters

backup

Performs a single unscheduled backup of the ERSSD.

dbfile_dir, 'path'

Specifies a new directory for the ERSSD database file.

translog_dir, 'path'

Specifies a new directory for the transaction log file.

logmirror_dir, 'path'

Specifies a new directory for the transaction log mirror file.

path

The path to the new directory.

Examples

Example 1

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

Usage

Permissions

You must have"sa" privileges to execute this command.