rep agent 问题
今天安装了复制系统。安装完成后，测试能运行，结果到下午就发现不再复制了。但是在rs服务器上显示health.检查主数据库，发现rep agent 的marker不正常：
Replication Agent Recovery status
dbname connect dataserver connect database status rs servername rs username
------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------
gtcp ss1_pfq_acs_gtca7_a gtcp not active rs1_pfq_acs_rs1_a sa
Replication Agent Process status
dbname spid sleep status retry count last error
------------------------------ ----------- ------------------------------ ----------- -----------
gtcp 1424 not sleeping 0 14069
Replication Agent Scan status
dbname start marker end marker current marker log recs scanned oldest transaction
------------------------------ ------------------------------ ------------------------------ ------------------------------ ---------------- ------------------------------
gtcp (6598729,0) (7049635,9) (6617367,33) 901 (6617367,32)
Replication Agent Configuration
dbname auto start rs servername rs username connect dataserver connect database scan batch size scan timeout retry timeout skip ltl errors batch ltl send warm standby xacts send maint xacts to replicateha failover skip unsupported features short ltl keywords send buffer size priority send structured oqids data limits filter mode schema cache growth factor
------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------ --------------- ------------ ------------- ------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------
gtcp true rs1_pfq_acs_rs1_a sa ss1_pfq_acs_gtca7_a gtcp 1000 15 60 false true true false true false false 2k 5 false off 1
Replication Agent Security Configuration
dbname security mechanism unified login msg confidentiality msg integrity msg replay detection msg origin check msg out-of-sequence check mutual authentication
------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------
gtcp n/a false false false false false false false
请大家帮我分析一下吧，我对复制系统还不是很熟悉，出现此状况的原因和解决办法？
另外，我在安装第二台MSA 的时候，subscription 只是 definded的状态而没有valide 很奇怪，我用的是同样的scripts 安装第一台MSA,运行正常，纳闷的很。是不是安装第二台MSA的时候有什么特殊的过程呢？
先谢谢大家的建议了。
[ 本帖最后由 altasha 于 2008-3-1 07:51 编辑 ] 把脚本贴上来看看,把日志文件贴上来看看
学习一下
用sysadmin log_first_tran
然后用rs_helpexception 看看错误 先sp_stop_rep_agent 再dbcc settrunc('ltm','ignore')，然后到rssd库去rs_zeroltem xxx,xxx
再回到那个库去dbcc settrunc('ltm','valid'),最后再sp_start_rep_agent之后看看
估计是发生过truncate table或dump tran xxx with nolog造成的 thanks a lot, I'll try it.:)
页:
[1]