Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Ikariux
Starting Member
16 Posts |
 Posted - 2010-08-31 : 01:40:20
|
| HelloHelp needed with replication errors.I have two SQL servers (PB and SB) with same named database "DATA1".I have created REPL-Merge job in SB server to replicate DATA1 tables every 5 minutes between these databases:-Publisher [PB] -PublisherDB [DATA1] -Publication [DATA1 DB] -Subscriber [SB] -SubscriberDB [DATA1] -SubscriptionType 1 -SubscriberSecurityMode 1 -Distributor [PB]Replication job is doing fine and starts to fail when i configure mirroring for SB server. I want to know how mirroring affects this job and how can i solve this problem?REPL-Merge job error:Connecting to Subscriber 'SB'<nl/>2010-08-27 06:45:01.011 Category:NULL<nl/>Source: Merge Replication Provider<nl/>Number: -2147201019<nl/>Message: The subscription to publication 'Publication' could not be verified. Ensure that all Merge Agent command line parameters are specified correctly and that the subscription is correctly configured. If the Publisher no longer has information about this subscription<c/> drop and recreate the subscription. <nl/>2010-08-27 06:45:01.011 Category:SQLSERVER<nl/>Source: SB<nl/>Number: 20026<nl/>Message: The publication 'Publication' does not exist.,00:00:01,0,0,,,,0 Thank You for help in advanceedit: moved to proper forum |
|
|
DariusM
Starting Member
1 Post |
Posted - 2010-08-31 : 10:07:46
|
| If merge replication is to be used, mirroring can be enabled only on the publishing database, on subscriber it will not function. If you have to mirror the subscribing database, use snapshot or transactional replication instead.--Greetings from NVB :) |
 |
|
|
|
|
|
REPL-Merge errors