Sybase full-Database Replication procedure

This document describes the full-Database Replication procedure of Sybase. Copy server name: HRB_REP master database server and master database HRB_HB.maindb to backup database server and backup database HRB_HB_REP.maindb

1. The interface information of the above three servers must be included in the replication server and the interfaces of the ASE database. 2. Log On with the user installed on the replication server. 3. use/repsrv/REP-12_5/install/rs_init to install the replication server 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 database server name HRB_HB_REP 3.2.2 Create RSSD for installing the system database of the replication server: If this database has not been created, select Yes 3.2.3 SA password: enter the sa password 3.3> RSSD Device Information 3.3.1 Size of the RSSD Database: Enter the Size of the HRB_REP_RSSD Database 30-50 M) 3.3.2 RSSD device name: enter the name of the Database device 3.3.3 if no device is created in the Database, select Create the RSSD device and enter the device file name and Size 3.3.4 Size of the RSSD Database: enter the size of the HRB_REP_RSSD log 30-50 M) 3.4> Disk Partition 3.4.1 The Partition file must exist. You can use> filename (or touch filename) to create 3.4.2 Disk Partition Path: enter the partition file name 3.4.3 Logical Identifier for Disk Partition: Enter the Logical name 3.4.4 Size of Disk partition in the copy server: Enter the Partiton Size (you must allocate enough space, otherwise, an error occurs due to full partition during large transaction replication.) 3.5> if all the options are in the complete status, do not exit rs_init after pressing ctrl-a to create a replication server, 4. execute settings on the master database and backup database servers respectively. The database server can copy isql-Usa-P.
 
  
-S
  
   
1> use master 2> go 1> sp_configure 'Enable rep agent Threads', 1 2> If the select into option is not set for maindb, you need to set 1> use master 2> go 1> sp_dboption maindb, 'select ', true 2> go 1> use maindb 2> go 1> checkpoint 2> go5. run isql-Usa-P-S on the replication server.
   
    
1> create logical connection to HRB_HB.maindb 2> go6. Add the master database to copy in rs_init, select add a database to the replication system 6.1> Replication Server Information 6.1.1> enter the replication Server Name HRB_REP 6.2> Database Information 6.2.1> SQL Server Name: enter the master Database server name HRB_HB 6.2.2> SA password: Enter the sa password 6.2.3> database name: Enter the master Database name maindb 6.2.4> Will 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 master server Name HRB_HB 6.2.6.3> Logical DB Name: Enter the master database Name maindb 6.3> if all options are in the complete status, add the database. run isql-Usa-P on the master database server.
    
     
-SHRB_HB 1> use maindb 2> go 1> sp_reptostandby maindb, "ALL" 2> go 1> grant role sa_role to maindb_maint 2> go executes isql-Usa-P on the backup database server.
     
      
-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> go8. synchronize primary database HRB_HB and backup database HRB_HB_REP login, role, permissions, etc, ensure that the login IDs of the two machines are consistent. add the backup database to copy in rs_init, and select add a Database to the replication system 9.1> Replication Server Information 9.1.1> enter the copy Server name HRB_REP 9.2> database Info Rmation 9.2.1> SQL Server Name: Enter the backup Database Server name HRB_HB_REP 9.2.2> SA password: Enter the sa password 9.2.3> database Name: Enter the master Database name maindb 9.2.4> Will 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: Enter standby 9.2.6.2> Logical DS Name: enter the master server Name HRB_HB 9.2.6.3> Logical DB Name: Enter Master database Name maindb 9.2.6.4> Active DS Name: Enter the master server Name HRB_HB 9.2.6.5> Active DB Name: Enter the master database Name maindb 9.2.6.6> Active Db sa password: enter the master database sa password 9.3> if all options are in the complete status, add Database 10. from the master database dump to the backup database load & online11. restore the connection isql-Usa-P-SHRB_REP 1> resume connection to HRB_HB.maindb 2> go 1> resume connection to HRB_HB_REP.maindb 2> go12. the parameter for modifying the backup database HRB_HB_REP is consistent with that of the master database HRB_HB, the number of locks is better than that of the master database.