Hi Gail

As things stand, transactions are mirrored from Server A to Server B. Server B then snapshots the relevant databases and tables/views are created from the snapshots for people to run queries against.

(I'm assuming for now that the snapshots are read-only).

I want to merge servers B & C into the production server, but I also need the same data on the dev server (please, don't ask!).

In a nut-shell, I want the easiest/most robust method of getting the data from server A to Servers D & E as quickly as possible.

I'd be happy with the snapshots that mirroring uses (as that's what happens now) but you can't mirror to two different servers.