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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 sql replication

Author  Topic 

2revup
Posting Yak Master

112 Posts

Posted - 2007-01-07 : 21:08:59
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
   

- Advertisement -