
Support
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
In SQL Server if Snapshot Agent is turned on accidentally then we can observe the table locks
Environment
For one of the customers, we observed that the snapshot agent was running which causes locking on database tables. Replicate never use snapshot agent to sync data as like native SQL replication. After stopping and disabling the snapshot agent no locks were observed.
NOTE: For any reason, if you create Publication manually then we have to make sure that the Snapshot agent is not created/disabled.
361 Views