SQL Server Performance

Merge Replication...

Discussion in 'Performance Tuning for SQL Server Replication' started by Jester99, Apr 29, 2004.

  1. Jester99 New Member

    Greetings to all & sundry...<br /><br />I am trying to sort out a merge replication problem.<br />Merge replication has fallen over in stockholm<br /><br />Publisher & distributor=Stockholm (& is enabled)<br />pulication ... already created<br />pull subcription : subscriber is an 0slo Server.<br /><br />since updates have been taking place in oslo & stockholm since replication went down...<br />I cannot reinitialise the snapshot with "drop & recreate tables" option enabled.<br /><br />I have:<br />1. removed initial subcription.<br />2. removed initial publication.<br />3. created new publication with "Leave destination table untouched"<br />4. created new pull subscription, with "Do not initilize, subscriber already has data & schema" option<br /><br />This has not worked because at the new snapshot agent, a message is displayed:<br />The process could not bulk copy out of table 'contD03723822F4A4835BE114E1A4305B853'. <br />(this table does not exist in either of the replication databases... it must be setup in MSDB as part of replication).<br /><br />Can Anyone help ... please!?<br /><br />Thanks<br />Jester99[<img src='/community/emoticons/emotion-6.gif' alt=':(' />]<br /><br /><br /><br />
  2. satya Moderator

    What is the level of service pack on SQL?
    Try to rerun the snapshot agent and if this doesn't work follow the procedure:
    Backup the database to a temporary database, then drop your database, then recreate all the tables.

    From here, when all your tables are empty, start transactional replication, then copy all your data back from your temporary database.


    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page