1 out of 1 rated this helpful - Rate this topic

Administering and Monitoring Change Data Capture

SQL Server 2008

To administer and monitor change data capture, you must keep track of various aspects. This section provides information about change data capture Agent Jobs and data types.

In This Section

The topics in this section describe how to administer change data capture.

Capture Job: Describes the capture job and its parameters.
Cleanup Job: Describes the cleanup job.
Monitoring the Change Data Capture Process: Describes how to use dynamic management views and the SQL Server data collector to monitor change data capture.
Data Type Considerations for Change Data Capture: Describes the behavior and limitations for several column types.
Change Data Capture and Other SQL Server Features: Describes how change data capture interacts with transactional replication, database mirroring, and other features.

Concepts

Using Change Data

Other Resources

Overview of Change Data Capture

Configuring Change Data Capture

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD