Re: How update publisher db in case it fails ???

Tech-Archive recommends: Fix windows errors by optimizing your registry

Please have a look at transactional replication with queued updating
subscribers, or bidirectional transactional replication - either would do it
for you.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)


.

Relevant Pages

  • Transactional Replication with Immediate updation DBNETLIB problem.
    ... I am trying to set up Transactional replication with immediate ... Publisher SQL server is installed on Windows 2003. ... immediate updation only, ...
    (comp.databases.ms-sqlserver)
  • Re: Replicating over VPN to non trusted workgroup
    ... Looking for a SQL Server replication book? ... transactional replication) to publications on my SQL Publisher. ... My stumbling block is permissions to the \\myserver\repldata folder on our ... My plan is that I set up the pull subscriptions, create the snapshots and ...
    (microsoft.public.sqlserver.replication)
  • Re: Order of replication flow
    ... for transactional replication, ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • Re: Whats the best replication model I can implement?
    ... transactional replication. ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • Re: Best way to keep a database clone syncd
    ... I figured that when we have a schema change, ... Does it matter that they would be different versions of SQL Server? ... There is a wizard in SQL to handle log shipping for you. ... Transactional replication applies changes as normal t-sql insert/update statements, but does not get all schema bblects. ...
    (microsoft.public.sqlserver.server)