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 stops after every two days

Author  Topic 

chander_2580
Yak Posting Veteran

76 Posts

Posted - 2008-07-05 : 14:30:53
Hi Gurus!!

i am facing problem with replication, replication stop working after almost every two or three days and when i start the merge agent it will start working again. i have checked all the related options for merge agent as well as i have set up replication from scarp thrice but all in vain.. please help me out of this issue.
type of replication is merge replication with push subscription.

waiting for early reply and solution

Regards
chander

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-05 : 22:10:36
Did you specify expiration date in replication?
Go to Top of Page

chander_2580
Yak Posting Veteran

76 Posts

Posted - 2008-07-06 : 13:57:09
meta data expired after 14 days if not in synch .. rest is default
this is a merge replication with continuous update subscribers.
Please let me know in case u need more information

Thanks
Chander

quote:
Originally posted by rmiao

Did you specify expiration date in replication?

Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-07-07 : 10:11:07
Any error in Replication monitor or error log?
Go to Top of Page

chander_2580
Yak Posting Veteran

76 Posts

Posted - 2008-07-13 : 12:01:06

ya it says process could not enumrate changes...
but when i restart replication it will start working again



quote:
Originally posted by sodeep

Any error in Replication monitor or error log?

Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-13 : 16:35:12
Take look at this one:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=356774&SiteID=1
Go to Top of Page
   

- Advertisement -