Replication and merge issues

[cfbeginner]

Hi All,

Our Publisher replication servers received the error:
The merge process was unable to update last synchronization information at the Subscriber.(source: merge replication Provider(agent); Error numer:-2147199481)

The log fiel for database 'sales' is full. Backup the tranasaction log for the database to free up some log space.

I'm fairly new to SQL replication method, what can I do to fix this???? A step by step guide would be helpful.

Thanks

 

[JohnBates]

gfong,

To reduce the size of the Log file..... do this:

1. BACKUP LOG databasename WITH TRUNCATE_ONLY

2. DBCC SHRINKFILE ('log_file_name',TRUNCATEONLY)

Please post back whether or not this worked.
John

 

[cfbeginner]

John,

Thanks for your reply. My problem is that I don't have any hard disk space for the log file. So, I have to delete some files on the server to create more space and now is working.