Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  Trans Replication SQL 2005

Author  Topic  Jaapie Starting Member 7 Posts Posted - 2006-04-04 : 08:41:19 Hi, I have a central DB on a single publisher that I want to use to publish to 2 subscribers (seperate servers) The replicated data will be identical on both subscribers. Data will only be updated on the single publisher. My question is does SQL replication use a 2 phase commit or some other transaction gaurentee that changes will be applied to both subscribers or not at all. Reason being we currently serve web site queries from same DB that our production department writes to and I am wanting to seperate this and supply a DR (2nd subscriber) I therefore need to gaurentee all changes are always propagated to both subscribers. thanks