Configuring the Secondary SQL Servers

Use the Server Configuration dialog box to configure the secondary SQL servers.

To configure the secondary SQL servers:

  1. In the Administration tool, expand Replication and double-click Database.
  2. In the Database dialog box, click Add Server.
  3. In the Server Configuration dialog box, in Server Name, select the secondary SQL server name.
  4. For Max. Lag from Primary, enter a value.
  5. Click Add Member to assign users and groups.
  6. Click Test Settings and OK.