This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 60%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES8%3C/text%3E%3C/svg%3E)
we have transactional replication. since the data between publisher and subscriber are out of sync. we try to take a new snapshot. our system have multiple update/insert/delete processing running. the snapshot is stuck in "[99%] Locking published tables while generating the snapshot" for hours. how to complete the snapshot? What would happen if the new snapshot is stopped when it reaches to the re-trial limits . The SQL is 2017.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(307.2, 78%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZB%3C/text%3E%3C/svg%3E)
Hi, Its better to stop synchronize on subscription. Then reinitialize subscription & follow steps to generate snapshot. In worst case , you may drop subscription & add it again but its better you do all this out of production window. Hope this helps. Thanks.
The snapshot was taken 3 years ago. the reinitialize subscription was failed. some articles have millions records. How to take snapshot without locking?
Please look into this:
This is what I got from copilot.