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 |