Home Forums SQL Server 7,2000 Replication subscriber''s records disappear with merge replication RE: subscriber''''s records disappear with merge replication

  • Yes that is correct! A snapshot file is one way to create an exact copy at the subscriber for merge replication.

    The approach to making exact copies of two databases would depend on whether you have existing data in one or both databases. If both databases have data, then you will have to somehow get them to be the same, which simply involves copying from one to the other. Watch out for identity columns, which may require you to set different identity ranges for each database.