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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-03-18 : 06:21:09
|
| Ali writes "Hi,I have 2 Servers running MS SQL7 SP4, Standard Edition.Merge Replication is setup, Server 1 as Publisher and Server 2 as its subscriber.The subscription is setup push from the Server1 to Server2.It agent is setup to run continuously.At an instance one Server is Active and other is at standby state.There is nearly 30 seconds delay in between the two which ever is online It replicates its data after 30 seconds to the backup server.Is there any way I can make both the servers to commit the data at the same instance? So if one server get fails the other have the same data which is committed on the failed server.Right now when active server gets fails/ abrupt power down/ or even just give shut down command, then the other server unable to get the complete data. This way the nearly 30 seconds data is missing as for the new server.How to make replication to commit both at the same time ???Do I need to change the Replication Type ??Just want to achieve that both servers replicates data either way, and there should be minimum latency between replications.Regards,Ali" |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2003-03-19 : 00:39:29
|
| If Server2 is only a backup server why do you want to have Merge Replication? AFAIK latency time is lower in Transactional ReplicationSekar~~~~Success is not a destination that you ever reach. Success is the quality of your journey. |
 |
|
|
|
|
|
Replication Latency !