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

TNX, Paul, i have something strange, while i configured replication from
server1 to server2, i server2 all key were dissapeared, why it's happen. Also
i got an error message on ditributor " can't drop procedrue ", ( and i
configured not to change not to drop for all articles ) ????

Thanks in advance

Paul Ibison wrote:
>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)

--
Imagination is more important them knowledge. (A.Einshtein)


Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-replication/200509/1
.

Relevant Pages

  • Re: Windows 2003 AD, move from server1 to server2
    ... I only suggested more detail since Paul has an article up on his site. ... thought the article needing a bit more detail added to it. ... I've got a Windows 2003 server with Active Directory ... I want to kill server1 and only keep server2 running Active Directory. ...
    (microsoft.public.windows.server.active_directory)
  • Re: SRV records
    ... Paul Bergson ... If I look in this folder in DNS ... If I look in the same location in DNS on Server2, the SRV record is ...
    (microsoft.public.windows.server.dns)
  • push replication failing - firewall
    ... local admin user and made the SQL Server agent run with it. ... sa and gave it database owner on the replication database. ... I am able to register server2's sql server in EM, although I had to up the ... Server2 has a hosts file with the ip address of server1, ...
    (microsoft.public.sqlserver.replication)
  • Re: Error 18456, State 28000
    ... Server2 is just windows 2003, and is dedicated to sql server 2000... ... i have a group set up... ... users in this group doesn't get recognized by my new sql installation. ...
    (microsoft.public.sqlserver.security)
  • Re: Problem With Replication On Port 2433
    ... Is the distribution agent using the alias you configured for server2 in its ... Looking for a SQL Server replication book? ... why- I cannot switch it to port 1433. ... Connections through a server alias, ...
    (microsoft.public.sqlserver.replication)