This article is based on the whole library replication (warm standby)
Replication Server name: Hrb_rep
Primary database server and main library hrb_hb.maindb to back up the database server and backup library HRB_HB_REP.MAINDB
1. Both the replication server and the ASE database should include the interface information for the three servers above interfaces
2. Login with user installed by replication server.
3. Install replication server using/repsrv/rep-12_5/install/rs_init
(Ctrl-a accept Ctrl-b backward ctrl-x exit)
1>; Configure a Server product
2>; Replication Server
3>; Install a new Replication Server
3.1>; Replication Server Information
3.1.1 Enter the name of the replication server Hrb_rep
3.1.2 Is this Replication server the ID server Select Yes
3.2>; Replication Server System Database
3.2.1 RSSD SQL Server name: Enter the name of the database server on which to install the Replication Server System library Hrb_hb_rep
3.2.2 Create RSSD: If you have not built this library, select Yes
3.2.3 sa password: enter sa password
3.3>; RSSD Device Information
3.3.1 of the RSSD database: Enter the size of the HRB_REP_RSSD databases (30-50m)
3.3.2 RSSD Device Name: Enter the name of the database device
3.3.3 If a device is not established in the database, select Create the RSSD device and enter the device file name and size
3.3.4 of the RSSD Database: Enter the size of the HRB_REP_RSSD log (30-50m)
3.4>; Disk Partition
The 3.4.1 partition file must exist and can be created using >;filename (or touch filename)
3.4.2 Disk Partition Path: Enter file name for Partition file
3.4.3 Logical Identifier for Disk Partition: Enter Partition logical name in Replication server
3.4.4 size of Disk Partition: Enter the size of the Partiton (be sure to allocate large enough space to otherwise make a mistake when a large transaction is replicated because of Partition full)
3.5>; If all options are complete state, press Ctrl-a to create the replication server
Do not exit Rs_init after you create it and use it later
4. In the main point database and backup point database Server, respectively, execute
Set up the database server to replicate
isql-usa-p<password>; -s<database_servername>;
1>; Use master
2>; Go
1>; sp_configure ' Enable rep agent Threads ', 1
2>; Go
If MAINDB does not set the SELECT INTO option, you need to set the following
1>; Use master
2>; Go
1>; sp_dboption maindb, ' SELECT INTO ', True
2>; Go
1>; Use Maindb
2>; Go
1>; Checkpoint
2>; Go
5. Executing in Replication server
Isql-usa-p-s<rep_servername>;
1>; Create logical connection to HRB_HB.MAINDB
2>; Go
6. Add the main library to the Rs_init in the copy, select Add a database to the replication system
6.1>; Replication Server Information
6.1.1>; Enter replication server name Hrb_rep
6.2>; Database Information
6.2.1>; SQL Server Name: Enter the primary database server name HRB_HB
6.2.2>; sa password: Enter sa password
6.2.3>; Database name: Enter the main library name Maindb
6.2.4>; 'll database be replicated: Select Yes
6.2.5>; Is this a physical Connection for Existing Logical Connection: Select Yes
6.2.6>; Logical DB Setup
6.2.6.1>; Is this an active Connection or Standby Connection: Select Active
6.2.6.2>; Logical DS Name: Enter the primary server name HRB_HB
6.2.6.3>; Logical DB Name: Enter the primary database name Maindb
6.3>; Add database If all options are in complete state
7. Executing in the primary database server
isql-usa-p<password>; -shrb_hb
1>; Use Maindb
2>; Go
1>; Sp_reptostandby maindb, "all"
2>; Go
1>; Grant role Sa_role to Maindb_maint
2>; Go
Executing in the BACKUP database server
isql-usa-p<password>; -shrb_hb_rep
1>; Use master
2>; Go
1>; Sp_addlogin maindb_maint,maindb_maint_ps, @defdb = "Maindb"
2>; Go
1>; Use Maindb
2>; Go
1>; Sp_adduser Maindb_maint
2>; Go
1>; Grant role Sa_role to Maindb_maint
2>; Go
8. Synchronization of the main library HRB_HB and backup library Hrb_hb_rep login and role, permissions, etc., to ensure that the login ID of the two machines are consistent
9. Add Backup library to replication in Rs_init, select Add a database to the replication system
9.1>; Replication Server Information
9.1.1>; Enter replication server name Hrb_rep
9.2>; Database Information
9.2.1>; SQL Server name: Enter backup database server name Hrb_hb_rep
9.2.2>; sa password: Enter sa password
9.2.3>; Database name: Enter the main library name Maindb
9.2.4>; 'll database be replicated: Select Yes
9.2.5>; Is this a physical Connection for Existing Logical Connection: Select Yes
9.2.6>; Logical DB Setup
9.2.6.1>; Is this an Active Connection or Standby Connection: input Standby
9.2.6.2>; Logical DS Name: Enter the primary server name HRB_HB
9.2.6.3>; Logical DB Name: Enter the primary database name Maindb
9.2.6.4>; Active DS Name: Enter the primary server name HRB_HB
9.2.6.5>; Active DB Name: Enter the primary database name Maindb
9.2.6.6>; Active Db sa password: Enter the primary database sa password
9.3>; Add database If all options are in complete state
10. Dump from main library to backup library Load&online
11. Resuming connections in Replication server
Isql-usa-p-shrb_rep
1>; Resume connection to Hrb_hb.maindb
2>; Go
1>; Resume connection to Hrb_hb_rep.maindb
2>; Go
12. Modify Backup library Hrb_hb_rep parameters are consistent with the main library HRB_HB, the number of locks is best greater than the main library.
