You are a database administrator for AIOTestKing.com. Your company uses merge replication to replicate data between SQL Server 2005 computers. Users sometimes report that data on some of the computers is out of date. When this happens, you discover that merge replication times out before the merge could complete. You need to ensure that you are automatically notified by SQL Server when this problem occurs. What should you do?
A.
Enable the Warn if a merge length for LAN connections exceeds the threshold warning.
B.
Enable the Warn if a subscription will expire within the threshold warning.
C.
Create an operator in SQL Server Agent.
D.
Configure and enable Database Mail.
Explanation:
To set thresholds and warnings for a merge publication 1. Expand a Publisher group in the left pane, expand a Publisher, and then click a publication.
2. Click the Warnings and Agents tab.
* Enable a warning by selecting the appropriate check box:
* Warn if a subscription will expire within the threshold * Warn if a merge length for dialup connections exceeds the threshold * Warn if a merge length for LAN connections exceeds the threshold * Warn if rows merged per second for LAN connections is less than the threshold * Warn if rows merged per second for dialup connections is less than the threshold 3. Set thresholds for the warnings in the Threshold column. For example, if you selected Warn if a merge length for dialup connections exceeds the threshold in step 3, you could select a time of 10 minutes in the Threshold column.
4. Click Save Changes.