MSSQL mirroring parameters

The following table describes the MSSQL server mirroring parameters worksheet for building or copying a database. You need these values when you set up the mirror database.

Parameter

Description

Mirror Database Server Name

Specifies a name for the mirror Database Server. The host name must have a vaild IP address.

Mirror Control-M/Server Database

Defines the name of the Control-M/Server Database that is a mirror of the primary database.

NOTE: Limited to 29 alphanumeric characters (including underscores). Capital letters are not allowed.

Control-M/Server Mirror DBO Username

Defines the name of the database server administrator.

Control-M/Server Mirror DBO Password

Defines the password for the Control-M/Server database owner. The password must begin with a letter (A-Z, a-z) followed by 5 to 29 alpha-numeric characters (includes underscores). If the specified password is longer than 30 characters, only the first 30 are accepted.

Default: password

Confirm DBO Password

Confirms the database owner password.

Mirror Data Device Physical Full File Path

(Building only) Specifies the full file path to the Mirror Data Device. The location of the Mirror Data Device must be on the Secondary database and the full path must be valid.

Mirror Log Device Physical Full File Path

(Building only) Specifies the full file path to the Mirror Log Device, which creates the Mirror Log Device on the Secondary database.

Mirror database Administrator password

(Building only) Specifies the administrator password of the database server.

Force (default: Y)

Y,N

Data File Size

Defines the database data size in MB created in the database server. The data size must have a numeric value.

Log File Size

Defines the user database log size in MB created in the database server. The log size must have a numeric value.

Encoding (default: LATIN1)

LATIN1, CJK

Parent Topic

Mirroring parameters