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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-01-21 : 08:51:48
|
| Anbalagan writes " I have implemeneted Trascational replication using Server 'A' as publisher as well as distributor.Configuration: 1.OS-Windows 20002.SQLServer 20003.SQLServer Service Pack 2My Replication Fails beacuase:1.Somtimes Log Reader Agent stops with the following error. "This process could not execute 'sp_replcmds' on <server>"what would be the cause?If it is beacause of insufficient memoryIs there any way to mointor it?2.Distribution agent also stops with following error message. a.This process could not execute '{callsp_MSget_subscription_guiid{1}}' on <server> b.The agent is suspect.No response within last 10 minutes. 3.Incase of remote subscriber,if the distribution agent not able to connect to the subscriber within 10 attempts it will be stopped.Can we change this default value (10 times)?4.I have read subscription expiration can be set as indefinite by setting its value to "0".But when i tried,it shows that value should be between 1 and 32767.What should i do?Thanks in advance. " |
|
|
|
|
|
Transactional Replication Failure