I am very new to the whole sql replication, i am trying to replicate with 2x 2000sql std machines
One is to be the distrubuter and the publisher (merge type by the way) the other to be the subscriber.
I have downloaded and followed step by steps religiously however i have nothing but isses with this. I have used the wizards i am getting various errors.
the merge client comes up with an error after looking in the event view i find i have the following error
Event Type: Information
Event Source: SQLSERVERAGENT
Event Category: Job Engine
Event ID: 203
Date: 8/01/2007
Time: 12:52:17 PM
User: N/A
Computer: FAILOVERSQL2000
Description:
SubSystem Message - Job 'FAILOVERSQL2000-PTO-PTO-ELCOM-TEST-1' (0x96AD1DBC3E5A9541A6C72C4CCFBF5AED), step 2 - The schema script '\\FAILOVERSQL2000\ReplData\unc\FAILOVERSQL2000_PTO_PTO0108120754\forums_AddUserToRole_5110.sch' could not be propagated to the subscriber.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
What can i do to get this fixed?
Thanks
From the subscriber, can you access that file using that particular UNC path - \FAILOVERSQL2000\ReplData\unc\FAILOVERSQL2000_PTO_PTO0108120754\forums_AddUserToRole_5110.sch. If not, then your share is not set up properly.
However you should be able to use replication monitor to get more detailed information. Open replication monitor, add your publisher, then drill down into failed error message where you should have more detailed history on why it cannot be propogated to the subscriber. If you still need help, please post back here.
No comments:
Post a Comment