Re: 2 DBs replicate on a single server

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

John,
using the subscription wizard, you should be able to select the publication
server and then the subscription database. As far as I know, the publishing
server doesn't need to be enabled as a subscriber - it is by default.
Perhaps it's different with a remote distributor - is that your scenario? In
this case right-click the replication monitor and enable the publisher
server as a subscriber.
Rgds,
Paul Ibison




.

Relevant Pages

  • Re: Host Name Change and Replication
    ... the msdb.sysjobs did still contain PDB01 as the server originator and this caused the 14274 error about the MSX. ... I then added accountName user to the Security folder again, reenabled replication, and then made sure each agent was using the accountName and tested the replication. ... Unfortunately on DGP09 and TDB10 in their> subscription folder each had a push subscription pointing to PDB01 which no> longer exsists. ...
    (microsoft.public.sqlserver.server)
  • Re: Is this merge replica model possible?
    ... Download Only) to only the transactions which occurred on the publisher flow ... Looking for a SQL Server replication book? ... > A user subscribes and downloads subscription X. ... > Is this model a total variant from the normal Merge Replica model? ...
    (microsoft.public.sqlserver.replication)
  • Re: sync over the Internet
    ... Looking for a SQL Server replication book? ... how do I connect to Publisher? ... Once this is done they are ready to set up their subscription. ...
    (microsoft.public.sqlserver.replication)
  • Re: SQL Compact Merge replication no longer works after VS SP1 is
    ... All i had done is installed the Server Tools 3.5 sp1 and re ran the ... subscription, ... case after installing VS 2008 SP1 the merge replication gives the following ...
    (microsoft.public.sqlserver.replication)
  • Re: SQL Compact Merge replication no longer works after VS SP1 is
    ... subscription, ... The merge process could not connect to the message file from Subscriber ... Check to ensure that the server is running. ... Initializing SQL Server Reconciler has failed. ...
    (microsoft.public.sqlserver.replication)