Re: New to Replication

Tech-Archive recommends: Speed Up your PC by fixing your registry

What about the alternate synchronization partner?

José.

"Hilary Cotter" <hilary.cotter@xxxxxxxxx> wrote in message
news:%23zmkjND0FHA.2960@xxxxxxxxxxxxxxxxxxxxxxx
> Its not really possible in SQL 2000, but it looks like the peer-to-peer
> replication model in 2005.
>
> You have to look at how the data flows. If it flows only from the
publisher
> to the subscribers it might be possible to convert a subscriber to a
> publisher by applying the publication creation script on one of the
> subscribers you wish to promote the new publisher. Then make all other
> subscribers subscribers of this new publisher.
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Wind" <Wind@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:4AF7A0BF-DB5F-43E8-BD2C-D7F1EE5E6098@xxxxxxxxxxxxxxxx
> > I am new to replication. Please forgive me if this sounds silly.
> >
> > I have one publisher and several subscriber, all in different locations.
> In
> > case of emergency and I have to shut down the publisher, I want to use
the
> > one of the subscribers to process our business, and I want to turn this
> > subscriber to a new publisher. Is this possible? What kind of
replication
> > should I use?
>
>


.

Relevant Pages

  • Re: Merge or Trans with QUS best when publishing partitions of database to slow subscribers
    ... With queued replication the single queue does serve all subscribers. ... No real conflict detection and resolution. ... The majority of the DML should originate on the publisher. ...
    (microsoft.public.sqlserver.replication)
  • Re: Behaviour of Merge Replication
    ... So the branch office should be the publisher, ... would you still use a Transactional Replication after knowing this? ... I normally use pull for over 10 subscribers. ... For the merge publications use central publisher in your head office. ...
    (microsoft.public.sqlserver.replication)
  • Re: MS access and SQL Server
    ... MSDE or Access for merge replication - I would select MSDE as it obviously ... Microsoft Jet 4.0 does not support case-sensitive sort orders. ... create publications for Jet 4.0 Subscribers. ... Publisher, create a pull subscription at the Jet 4.0 Subscriber. ...
    (microsoft.public.sqlserver.replication)
  • Re: Deadlock between Distribution Agent and Distribution Agent Cle
    ... This part of the stored procedure sp_MSget_repl_commands is ... written by the Log Reader for replication to subscribers. ... SQL Server DBA ...
    (microsoft.public.sqlserver.replication)
  • Re: HELP! full text catalogs disapearing!
    ... I have Transactional Replication running once a week (The Publisher is only ... I rebuild that catalog each time because that only takes about ... When I come back the next day, the Subscribers data is sync'ed, but all FTI ... I dont understand how a transactional replication, ...
    (microsoft.public.sqlserver.fulltext)