Check Details
Check objective
Ensure data consistency for full + incremental synchronization.
Feature Description
When snapshot isolation is not enabled on the source, a one-click repair SQL is provided.
It supports skipping snapshot isolation checks (by using READ COMMITTED + NOLOCK instead).
Check logic
Check whether ALLOW_SNAPSHOT_ISOLATION is enabled for all databases on the source.
When it is not enabled, the task issues a warning and provides a repair SQL.
Fixing Method
The repair SQL is automatically generated by the check item. Refer to the following:
ALTER DATABASE [database_name] SET ALLOW_SNAPSHOT_ISOLATION ON;