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

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

You'll need to initially have a synced up system - publisher and subscriber.
You can use backup and restore for this. Each constraint should be set as
NFR, and the identity ranges will need partitioning to avoid conflicts. The
subscriptions are set with @sync_type = N'none' as well as
@loopback_detection = 'true'
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)



.

Relevant Pages

  • Re: merge Replication with a Notebook not in domain
    ... not associated with a trusted SQL Server connection. ... I have set up all SQL Server login in both publisher and subscriber.Also ... Looking for a SQL Server replication book? ... subscriber ...
    (microsoft.public.sqlserver.replication)
  • Re: Transformable v. regular subscriptions
    ... manually and have some fake values selected for the excess columns. ... snapshot agent can't be "told" to skip the excess columns at the subsriber so ... Looking for a SQL Server replication book? ... moves from the Publisher to the Subscriber. ...
    (microsoft.public.sqlserver.replication)
  • Re: Newbie to Replication Subscriptions
    ... I'm not talking about the SQL Server agent on the publisher rather the ... For push subscriptions the publisher connects with the snapshot share on the ... publisher reads the files and bcp's them to the subscriber. ...
    (microsoft.public.sqlserver.replication)
  • Problems planning replication with a subscriber on the road
    ... synchronize on the road despite changes on his IP address. ... I preview problems with the changing IP address of the subscriber. ... When the laptop goes on-line from a remote site it will receive a random IP ... I insist because the problem of synchronization with SQL Server ...
    (microsoft.public.sqlserver.replication)
  • RE: Custom Conflict resolver with Stored Proc
    ... SP conflict resolvers do not work with SQL Server CE, ... cannot be retrieved from the subscriber db. ... Custom Conflict resolver with Stored Proc ...
    (microsoft.public.sqlserver.ce)