Merge Replication: Content of MSmerge_* Tables

Hi All,
I have set up MERGE Replication with NOSYNC option and 14 days subscription
retention period.
My both the servers are in sync with each other since when I started
replication a month back.
But I find there are thousands of records in MSmerge_contents,
MSmerge_tombstone, MSmerge_genhistory.
I want to know how to get rid of all the unwanted entries from the above
tables.
Regards
Javed Iqbal
Javed,
please run sp_mergemetadataretentioncleanup and see if this helps.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Hi Paul
Thanks for your reply.
This stored proc is already been running by the merge agent every minute.
Any other option is highly appreciated.
Regards
Javed
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:elzAKGIBGHA.628@.TK2MSFTNGP10.phx.gbl...
> Javed,
> please run sp_mergemetadataretentioncleanup and see if this helps.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||Also I am getting these types of errors
The merge process could not perform retention-based meta data cleanup in
database 'ABC'.
Regards
Javed
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:elzAKGIBGHA.628@.TK2MSFTNGP10.phx.gbl...
> Javed,
> please run sp_mergemetadataretentioncleanup and see if this helps.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||Javed,
you could try increasing the merge agent's querytimeout.
Also, you could try reindexing the metadata tables.
If this doesn't help, please enable logging on your merge agent:
http://support.microsoft.com/support.../q312/2/92.asp
and post up the log file.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Hi Paul,
Attached is my agent logging file. I still have thousands of records into
those tables.
Thanks in advance
Regards
Javed Iqbal
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:%23SBHyfJBGHA.2708@.TK2MSFTNGP12.phx.gbl...
> Javed,
> you could try increasing the merge agent's querytimeout.
> Also, you could try reindexing the metadata tables.
> If this doesn't help, please enable logging on your merge agent:
> http://support.microsoft.com/support.../q312/2/92.asp
> and post up the log file.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
begin 666 Merge_Replication_Verbose_Logging_For_Errors.zip
M4$L#!!0````(`(5CE3-[['W5.0X``*/I`0`P````365R9V5?4F5P;&EC871I
M;VY?5F5R8F]S95],;V=G:6YG7T9O<E]%<G)O<G,N='AT[9UK3^-(%H:_1\I_
M*.T7@.D0SMI- B#3:98$=M00T2WI:&JU6D6,7X&G'E?$%.K.:_[ZG;'(AF,2W
MQ$[R2B,-':=.'=OO>:M<>6Q?B-'8M1Z?...8P#IFF* J[L0Q7>.+!9Q?"'0E7
M]RWAU&NSCWO_OF8][CYSE]WSD6T9X3?8^2-W_"Z[&=\%@.TO=UP>ZQZ.O?;H9
M3SYX^V<O&'@.+7SVMU^JU.^X:%(P2&(YL[O,N4^JU"^$XW/ MYY'Y@.EU:GN]:
M@.\ 7+CN(Z?,@.;8/C`]ES]'?L7M1KE_^\Z759W(&HU[YQUZ.C0)EVCA7E6#D]
MH90#CXZ1HP]I!\R!J-?.[SXS0S@./PAWJCD&?:M0C!7GSF5JO^:[N>+H1'E9#
M'^D#._JNRW63"<<>=]EMO6:9=(RL!XOZ^",0/F?&DTZI_ZU><X33=P+;E@.W[
MAK"#H>.%@.<6+0]\.//V1`C;I@.Z'^@._GR:V&:S.:T!ZK6B39$+1>W.)R;S!9T
M5$TZ/M&&W^8;>,QRHJ#40M%:[[99CLE_T+:3URV4-K,MG[NZ'85K:RVM\YJ$
MY^L^'THUO-ODBA?F67_RV:?UVG]4[2=-_8F4W*;.NVVMJZCL_.:_<6>\R_YG
MZ+;-O%'_IO?(_>?H'+*_,H=YXO;()*&-@.H%M>4]TK!NWL>H\3-N).9%O*#*/
MVZ3L\ 1X(J!B.6*>^VR9[,$50S;4/3J8Q\?>V//"UAY[H5PX"T8C[C;HF_*4
M'K*?7S_X(,5J)?C>*_)E.'?JY5GK#[G[R/NZ-#%*LZ$<,=GK),3!NW\V%SXY
MS'5"%[,9N>+!HJILG!ZQENPIC)_ %^^FRHLUN;F$Z[7/CN5;NFW]26UA?GMF
M?C,ER&KUF2,,$5!'=-1-;M@.Z5>,_S$&X^U2FT?^CHIY\_#.=U[[\JW$X:T)[
M:D?S`>=9=^7>-;1V^W#:=K;]9WGF*1._\>:;1^&1E7E1#5#Q^V/^H_':I2R$
MBR_7U^=?/W^Y/3B<1IT&G31IS/J)VEQ>W9W_<D6VJWOLX$*8_(Y40%6\JN7U
MQ>?+UU;AGZM;7'RYN3N__]S[<MO[^MOUK,OA2'<M3S@.]?VSS=[.3-&7[W@.74
M=.$PT]GG8B]DSK-\]/)HK#9H,W?[%IWOCR9!T0@.:-[#_M2CHWC0BBVVRJD*T
MM %CHY#0OSYQ1I5O<,^C$QW8)AFG-* P=J+ QQ^-XW3V'X4[[I)1W7ZE<@.GG
M35W&XJ+4:[?!<"#K5UZT=4AY-Y11*/8-9$B5W+NZ_W9UGSQ+92'#<+HUS=.W
MAE1J(O!I'BBG/4/]NSQ/^B1M4MDQ76Q*][ >`QIG? IQ+1XMYRNUE.W(7:EX
MJ;*8[IC,Y;X[#K\D/3KT9MHIN@.0T9B((9Z()9!#3:J6]%M0FP45N[&7Y37AP
MPPMR%IITZ-$7N-:?N 5&P%T<`9O==KN :_V$8?)=ZR_KI!+7^F4FF.Q:/WF&
MF[C6SYX-KO5A?NLU/USK[]2U/JIWZZLWY7)-UF(O9,Y3[6O]^6*(NP)%-6SS
M6+;T["_1][I6@.)KUVCVG:N#/,DHX]7^])+8B-407T.\;MMXT?"V:4<*6[Q=,
M+(\9-M<=&2P8T48ZJ>&9I3,U&5/9_)0U=DTG-G08E]1"8<_DV6IXAS+J32^:
M-=.D^8D,0;CC(SI7,5^@.NO"I&^\H7(F)^X8OA@..*X/#D2>WV_OXZLH5N6I/J
MI-IR'KDG12J7L*:CPP>M;T743-8X[0>U&KSNH_E1AY?D*<NZG-5&GLD+YBD[
MY\RMKJ+DFGA@.J(>@.%@.2EYAOJX4^04XR<X$\0%/P)<H(_P9_@.3_ GR G^!$%M
MH3^]7\!JM^G3:/4NI,1<WS+H"!Z,7/$[::\?(0>QZ[<...94`6I]LC_NIFGDO
MUHCWY^22JC7_P8WP5Y6^X$:JED\B<.UQ/UF R6(?R4;3WB[W-=0S4@.-5B5R^
M;+)@.1%LY_:DPD\L`X9^R.FS+\+W#V.5$50G9/KG<F"V^RSUA/U/K-QV5"NME
MZZGZK;(<BUUK`Z@.24"4&\,0#>+N8&R@.3ALD'52[KI!)099D)Q HP1N3+<!%29
M/9MXJ#+[M6ZLH[Z%*F-9K30]PD#WS4 !9FXKF(E"W=M"33/GT0!50MZ5D;<&
MJ+)\R+"U`C+<,::RI-T%4@.E?WAI?/L5/;A#4&@.0%) !R@.C]!4/ G^!/\"?X$
M0<&?("?X$P2UW_ZT*<!QY%K"M?QQWW(\WPT,/S7H2#L@.HK7@.)'CC26<!/]3F
M\<.S_'QCM@.X`. )PW%K $33DZS%+UP`TY$Z.O:?%T) )P^2C(9=U4@.D:LLP$
M8P:47!EN@.H;,GDV*1TR^91IQ)0OS2Z0_D(P@.&5&H6U:H:>8K( !DA[^K(NW"2
M44U]JP9HR"+PP/8*/%#M[!8.6=;^@.H>$NV^-NW?P>QD$5:2@.SO![/N14N)S@.
M3Q 4_ ER@.C_!G^!/\"?("?X$06VA/R7G$0U;MX9>W^6&<,U4)&->DC)ZM*4I
MAKKE>)G:RFZ?+7^<J?&*9VK./V/R=(&1;+,I(JEI!3QC,DM\()A ,/&,25"5
M&,&K.()WBJ$J$X;)1U4NZZ025&69"<:,$;DRW 15V<G,MI3PC$F8W]:;7Q'L
M21H-@.\P$F8EBK\Y,)U&AIIGS@.,R$O"LG[^*6XC10E:DI0VT%9;ACSY @.L:7?!
M5,*7M\:7\0P2"&H=@.@.(3`#G!GR H^!/\"?X$?X*@.X$^0$_P)@.MIO?]IY,C+[
MV[M-W;+'?;F0E[II0APSKFG6=X:WE07>\H1-><M6*S_/F2D^>$[PG. YP7-B
M]E#%V<-9,3QGPC#Y>,YEG52"YRPSP9@.Q(E>&F^ YS\!SPOS*-3^PF& Q4:B[
M4JAIYBM@.,2'ORLF[N"4\%4_)+ 5P/-DOGK.DW07/"6_?&F\_P>]]$%21@.@.*/
M`#D5+R?X$P0%?X*<X$_P)_@.3_ ER@.C]!4%OH3\E!0SW5.[O5!?I/95/Z3\D/
M%V#K00:"'00J"%&,@.J-Y"I747I*LV\:&'R,#G0PA6=E(\6EIQ@.S!B1*\.U
MHX6YLHE'"Q/X8IH+0:"%>VQ^0 N!%J)0JU.HK>+0PBA@.&V@.AY%T9>;>!%NX&
M6JBN>GBBVMHMN+"T'09>"'_?%G]7@.1="4.L0%'X>AYS@.3Q 4_ G^!'^"/T%0
M\"?("?X$0>VW/R7'"UW^1W^&&&9Y$F*^!TY2_P'W,CV",1T9J6F+\.+<FZ[G
M'HS8S/HB[2SQ04>"C@.0="3H2XW 5QV&U@. <O)@.^3CXY<UDDEZ,@.R$XP9(W)E
MN DZ,GLVH"-A?NLU/]"1VTI'%D$*H=CWMM@.+F?. L(2\RY)W<0MJ&NC(U+!@.
M' HXSPIV=HN-+&EW04;"E[?&E\_PRQD$5:"@.5 6_[$-.A<L)_@.1!P9\@.)_@.3
M_ G^!'^"G.!/$%09@.BI\(?=#O- <6DX_#Y\X"2 !R_62E7.<8VL!0VRR*86H
MYG\"9(;H8!S!.()Q!..($;6*(ZI6#..8,$P^QG%9)Y5@.',M,, &:,R)7A)AC'
M[-G$,X[9+SYC'16,XQZ;'QA'/ $2A;IEA9IFOH*72T/>U9$W7BZ])XSCCKU<
MNJ3=!>,(;]\:;\?+QR"H=0@.*O]%#3O G" K^!'^"/\&?(*B$@.NK GR"GPN4$
M?X*@.*N%/ZR ,XUJ/7$NXEC_N6X[GNX'A]P4W4D4P](?^`YV=@.6Y\[_/AR.7/
M%G])%2+=4R!;BP!CBTT!QN;9C&!4L_*16>*#D 0A"4(2A"3&XRJ.Q\UB",F$
M8?(1DLLZJ00A66:",6-$K@.PW04@.V,W,J("1A?H68WX?Z`R$)0A*%NF6%FF:^
M`D(2\JZ<O(M;%%-!2):"##9S(X-J>81DS)Z)P#9I\N,S&LSE,6<NE[G2@.?\D
M6YES@.</NJ*M4QU,IJ]<+*ME'.B7=VU^OK\GBPLNP+GM=")I?N;ES!5V:20.]
M#88#:;WLDZ:V3M6SL];)J5P=]2*S*GE':&IU<WY[.;<O_]+I(LF47R?...N?R
M5^:RGII*F+K,1W8_S?,UK<;?CYC\[^.G[4_2H,&B=W7_[>I^_ J#&CE73=%1U
M+I]?N!.ZK,/]%^%^9]QUA7O,+IZX\9V-*>)TBRF,0+IN>)K*7E3&8B46*S%/
M6NL\J=5M?4C+I)C\)PR3;[%R62>56*PL,\%DBY7),]S$8F7V;+!8"...;K_EA
ML1*OK$&Q[V&Q%S+GP8(GY%V6O(M;\,1B9?K%2FW%8F7<4F1E% BN+7YM=O;MQ
M!PRW<V/:L2.^W.XJ)\#](:@.U""KK0 ]_@.IS@.3Q 4_ ER@.C_!G^!/\"?("?X$
M0>V&/[U?P%K7[=SB=U)NWQ1#W7*\3&UEM\^6/T[9..]]Y/P'-\(?9U*W-'7+
M'O?E4F#JII-]SO)JH-4WK<<U>Q*!2]DFV]NYN]Y5I...VE;.AG;+I?>D=)=M]
M[[*3M$NO\_?*9\P*=\OC;GD`J !0,=VIXG3GI)B[Y1.&R0>@.+NND$@.!JF0G&
MC!&Y,MP$@.)H]&P"H,+_UFA\`5-PMCT+=LD)-,U_!W?*0=W7DC;OE8[F_W7N?
M4'LED;E3[Q-:T^X"0(6W;XVWXWGX$-0Z! 6 `G*"/T%0\"?X$_P)_@.1!P9\@.
M)_@.3!+7?_I0<4/2M(>^3=W$_%=>8CUO-#G]N&,-LJ8N\8Y-->4>U,^,=E:QO
M'\K4`8!*`)4`*@.%48OBNXO!]NH0L2 $H) R3#ZA<UDDE@.,HR$XP9(W)EN F@.
M,GLV`"IA?NLU/P"5`"I1J%M6J(7,5P!40MYER;NX-3050&4IA&$<09CN$9=;
M!526M+L`*N'M6^/M^,$-@.EJ'H `$0$[P)P@.*_@.1_@.C_!GR H^!/D!'^"H/;;
MGPHE%.<`0VT!_U/8E/[3\M.%&#+01:6"VT\/]02P$"% `4````" "%8Y4S
M>^Q]U3D.``"CZ0$`, `````````!`" `````````365R9V5?4F5P;&EC871I
M;VY?5F5R8F]S95],;V=G:6YG7T9O<E]%<G)O<G,N='AT4$L%!@.`````!``$`
*7@.```(<.````````
`
end
|||Thanks Javed.
Occasionally you're getting network connectivity errors. When there are no
errors - most of the time - the metadata records are being removed. Apart
form the network errors, it all seems to be working correctly. You have a 14
days subscription
retention period which accounts for these tables not being fully cleaned
up - perhaps you can try reducing this retention period?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Thaks Paul for your prompt and through help.
Regards
Javed Iqbal
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:O343DsgBGHA.344@.TK2MSFTNGP11.phx.gbl...
> Thanks Javed.
> Occasionally you're getting network connectivity errors. When there are no
> errors - most of the time - the metadata records are being removed. Apart
> form the network errors, it all seems to be working correctly. You have a
14
> days subscription
> retention period which accounts for these tables not being fully cleaned
> up - perhaps you can try reducing this retention period?
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
sql