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:41:30
|
| 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 advance |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-08-31 : 07:11:58
|
| Please do not cross post:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=149515 |
 |
|
|
|
|
|
REPL-Merge errors