I need to add a new subscriber with snapshot and transactional replication and I'm trying to determine if I need to add the subscriber after-hours or not.
This particular database is already being replicated on a different server, so there is an existing publication.
- Does adding a subscriber to an existing publication generate a new snapshot?
- If not, will the publisher DB have any locks while the subscriber is being created?
Thank you for your help.