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
 Import/Export (DTS) and Replication (2000)
 Replication

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-03-18 : 06:21:46
Moin writes "Dear sir,

The scenario is like take that
OPERATING SYSTEM
Subscriber WindowsNT
Publisher Windows2000
SQLSERVER - 2000(both Subscriber and Publisher)

We established this setup two week before successfully.
publisher and subscriber everything we had done comfortable and after that we had synchronized all the data successfully then we broke the connection(the subscriber machine became standalone).
In the two-week period time the publisher server that is our company head office data, we have made it an entry
Now after two week, we make connection again the subscriber server in LAN.
And now we do synchroniz, the Synchronization give us successfully,
when I see the message,No Data need to be merged
And I checked physically the record,there had nothing been changes in record of subscriber table
Why? I do not know
After again I breake the connection immediately and make the changes in publisher server (one record added and one is update) then we do the same process. Now this time I get one record is updated and one is inserted in subscriber table
This time give us success fully result

Q1 -
What is the reason of my above mentioning query

second problem i am facing while Synchronization the data
Q2 -
The process could not read file 'c:\Program Files\Microsoft SQL
Server\MSSQL\Data\unc\ACCT_ORArqam_OrbPUb\20030128203151\apaccts_1.sch' due to OS error 3.

awaiting your feedback

Thanks"
   

- Advertisement -