Hi All,

We have one publication running on a master server with three subscribers running merge replication. We want to create a report server so that we can optimize the indexes for the report reads.

What we are wondering is what is the best way to do this keeping the overhead as low as possible on the publication server.

Option 1- Just add another push subscription to the reports server on the merge replication publication that is already present.

Option 2- Create a new one-way transactional publication to the reports server.

Option 3- Use scheduled log shipping.

I think there are probably more options.

Any help on this would be greatly appreciated.

Thanks,
Richard