HOW To modify a synchronization schedule for a push subscription in Replication Monitor Expand a Publisher group in the left pane of Replication Monitor, expand a Publisher, and then click a publication. Click the All Subscriptions tab. Right-click a...
HOW To specify synchronization schedules REPLICATION? On the Synchronization Schedule page of the New Subscription Wizard, select one of the following values from the Agent Schedule drop-down list for each subscription you are creating: Run continuously...
Cursor Advantages and Disadvantages Cursor advantages: Using cursor to getting multiple values. One cursor have multiple select statements Cursor parameters cursor cursor_name (parameter datatype) is select * from table_name where(condition) Where Current...
SQL Server Transaction Log There has always been some debate as to whether or not there are real benefits to be gained from accessing the information in the transaction log. This article will endeavor to answer that question by looking at the following:...
What type of locking occurs during the Snapshot generation? Locking depends on the type of replication used: In snapshot replication, the snapshot agent locks the object during the entire snapshot generation process. In transactional replication, locks...
Queue Reader Agent - The Queue Reader Agent is used with transactional replication with the queued updating option. The agent runs at the Distributor and moves changes made at the Subscriber back to the Publisher. Unlike the Distribution Agent and the...
Merge Agent - The Merge Agent is used with merge replication. It applies the initial snapshot to the Subscriber and moves and reconciles incremental data changes that occur. Each merge subscription has its own Merge Agent that connects to both the Publisher...
Distribution Agent - The Distribution Agent is used with snapshot replication and transactional replication. It applies the initial snapshot to the Subscriber and moves transactions held in the distribution database to Subscribers. The Distribution Agent...
Log Reader Agent - The Log Reader Agent is used with transactional replication. It moves transactions marked for replication from the transaction log on the Publisher to the distribution database. Each database published using transactional replication...
