mirror_auto_restart_interval_seconds
Use this parameter to indicate how frequently (in seconds) CDC Replication tries to automatically restart continuous mirroring for persistent subscriptions while an instance is running.
The default value of 0 means that CDC Replication does not try to automatically restart mirroring for a persistent subscription while an instance is running. In this case the subscription is automatically restarted only when the instance starts and if it previously stopped with a recoverable error. Set the restart interval large enough to handle the longest recovery time for the types of recoverable errors that are occurring. The recommended setting is 60 seconds. Increase or decrease as necessary to ensure that subscriptions restart successfully and promptly.
CDC Replication continues to try to restart mirroring at a defined interval until it is either successful, an unrecoverable error occurs, or you stop the subscription.
This parameter takes precedence over mirror_auto_restart_interval_minutes, which is deprecated.
- Applies to
- Source datastores
- Minimum Setting
- 0 seconds
- Maximum Setting
- 3600 seconds
- Default Setting
- 0 seconds