How Do I copy One Replicated Environment into Another?

[skippaNH]

I have Merge Replication running on two databases (Live & Test) to a secondary data center. How do I refresh the Test Environment with the Live Environment data with Replication running? I tried DTS, but it would not let me copy any data in because both DBs are being used in Replication. I finally backed up Live and restored it into Test, but that "broke" the publication on the Test db. Any help is much appreciated.

 

[Corran007]

Have you thought about setting up a snapshot replication from your live to test? You just set it as a on demand schedule or a reoccuring as needed schedule. I havent tried this but it should work. But I am unsure how sql server will handle it. Snapshot does a complete replace so make sure you dont need any of your test data