Prev: Merge Replication Question
Next: I would like a replication that not expired
From: KC on 15 Nov 2009 22:29
Hi,

I wanna to work on my project with Transactional (with Update) Replication
in distribute offices, it works fine. But I found if the Publisher (same
Mechine I use as Distributer) is shut down, or the network connection
between Subscriber is disconnected, I can not processing any data update(or
delete) in my Subscriber SQL Server.

Error message like: (Named Pipes Provider: Could not open a connection to
SQL Server ), (Msg id 10054), (Msg id 65535, SQL Server Network Interfaces:
Error Locating Server/Instance Specified) ..... etc

Is there any way to fix this case, so I can use my Subscriber SQL Server in
"offline", disconnected mode?

Thx




From: Paul Ibison on 21 Nov 2009 10:43
Yes - use a queued updating subscriber with a frequent schedule of the queue
reader agent. That way the subscriber doesn't depend on distributed
transactions with the publisher.
HTH,
Paul Ibison

 | 
Pages: 1
Prev: Merge Replication Question
Next: I would like a replication that not expired