I got a problem to do a Replication. After Snapshot agent has been finished the distributor agent (subscription) starts to run and after 3 days (because the db have 50GB) it was finished with a error:
"The subscription have been marked inactive and must to be reinitialized. NoSync subscriptions will need to be dropped and recreated "
After that I dropped the subscription and recreated another subscription with the option to use an existent schema (to it don't restart the snapshot). When I stared the subscription I got the follow error:
"Violation of PRIMARY KEY constraint 'PK__@snapshot_seqnos__096D671B'. Cannot insert duplicate key in object '#087942E2'."
How can I use this new subscription that I created without restart the snapshot?