SQL Server Transaction Log Information

Distributor

A distributor, DBRS_Distributor, is created by Syniti Data Replication to manage a log that keeps track of transactions for the source table. This is typically done when setting up the connection in the Enable Transactional Replication wizard, although you can also set or modify the distributor or system administrator login information in the Connection Properties dialog.

To create the distributor, your source connection should have system administrator privileges. If you encounter connection problems at this stage, you need to cancel the Replication Wizard and change the Source Connection Properties by selecting the source connection in the Metadata Explorer and choosing Connection Properties from the right mouse button menu.

Publication

If this field is left unedited, Syniti DR creates a publication in SQL Server called DBMotoPUB_ followed by the source database name. The publication is used to identify the tables involved in replication. One publication per database is created, so that several replications may use the same publication. To create the publication, your connection should have system administrator privileges as described above.

You can choose to edit the field and provide an existing SQL Server Publication Name. This approach is useful if you want to reuse replication objects which are already defined in the database and avoid creating additional work for the server in generating log information on specific tables.

Transaction ID

The ID for the transaction at which you want to start replication. If you want to change the transaction ID, click ... to open the Read Point dialog.

In the Transaction Read Point dialog, you can either retrieve the current transaction or the transaction for a specified date and time. If you enter a date and time, Syniti DR retrieves the first transaction after the time entered. This information is available and can be changed in the Replication Properties dialog after the wizard is completed.

Transaction Timestamp

The timestamp for the transaction above.

Read Interval (sec)

The frequency (in seconds) with which you want to check the log during replication. For example, if the setting is 90 seconds, Syniti DR will check the log every 90 seconds to see if any transactions have occurred that need to be replicated to the target table. This information is available and can be changed in the Replication Properties dialog after the wizard is completed.