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)
 Merge Replication Error

Author  Topic 

kasisunkara
Starting Member

2 Posts

Posted - 2006-08-28 : 08:40:34
In Merge Replication, I am not able to replicate one table having more than 5 GB data to the subscriber. If I have filter on the table I am able to do. I couldn't understand the problem? Any one having any idea on the same?

For your information.

I have 1.7GB free space in C drive. Is it a space problem in C drive? Actually my data base is storing in E drive. It has 30GB free space. But Sql Server installed in D drive it has 2 GB free space.

Error Message:

Replication-Replication Merge Subsystem: agent TRPSQL3-ThomsonResearch-TR PUb-TRPSQL2-7 failed. The merge process was unable to deliver the snapshot to the Subscriber. If using Web synchronization, the merge process may have been unable to create or write to the message file. When troubleshooting, restart the synchronization with verbose history log

I have got the above error message. I would appreciate you if you have any idea on the same.

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-08-29 : 17:01:20
the default location for the snapshots is going to be the REPLDATA folder. Chances are this is on your D: drive.

You can change the snapshot location by going into the properties of the publication and clicking on the 'Snapshot Location' tab.



-ec
Go to Top of Page
   

- Advertisement -