sql server replication: Hi All,

I would be grateful if you can give me any direction.

Case:
when we do log shipping to secondary server, DB on secondary server is state
read only, can read only DB replicate data to other server?

The purpose of this testing is that we are trying to figure which is the
best way to replcate data from west site to east site.

Thanks

Best Regards,
David

David,
this topology won't work. You could publish (using replication) to the
secondary server then republish to the east side.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Hi Paul,

Thank u very much.

Best Regards,
David

[quoted text, click to view]