This topic describes how to reset a change tracking task. You can reset a change tracking task to clear the configurations of the task and delete the data that is cached by the task.

Prerequisites

The change tracking task is in the Normal, Initial synchronizing, or Error state.

Impacts on billing

  • Subscription: no impact.
  • Pay-as-you-go: The change tracking task will enter the Not Configured state. You are not billed for the task when it is in this state. The billing restarts only after you configure and start the change tracking task.

Procedure

  1. Log on to the DTS console.
  2. In the left-side navigation pane, click Change Tracking.
  3. At the top of the Change Tracking Tasks page, select the region where your change tracking instance resides.
    Select a region
  4. Find the target change tracking task, and choose More > Reset in the Actions column.
    Reset a change tracking task
    Warning Resetting a change tracking task has the following impacts. Proceed with caution.
    • The change tracking task stops tracking data changes from the source database.
    • The configurations of the change tracking task are deleted. The status of the change tracking task changes to Not Configured.
    • Data changes that are cached by the change tracking task are deleted and cannot be restored.
  5. In the dialog box that appears, click OK.

References

For information about how to configure a change tracking task, see Overview of change tracking scenarios.