I have a very large transactions that has been done in the publisher db. Now those transactions cannot be replicated to the subscriber, because it's too big. Syslogs has more than 175 million + records.
My setup: Publisher (sql6.5), Distributor (sql2000), Subscribers (sql2000).
I wanted to execute sp_repldone to mark those large transaction as distributed however I can't figure out the page and row id for the parameter. I had to use page and row (instead of xactid and xact_seqno) because my publisher is sql 6.5.
Executing sp_repltrans or sp_replcmds (to find page and row) will hung my server, may be because syslogs is too large-- 175000000+.
Is there another way to find out the page and row id of a transaction? I can find out the xactid from syslogs but that's not gonna help me.
I can reset all transactions as distributed but if possible I don't want to do that. I only want specific transactions to be set distributed.
I would appreciate any suggestions.
Thanks!
Andel
Andel
andel@barroga.net
My setup: Publisher (sql6.5), Distributor (sql2000), Subscribers (sql2000).
I wanted to execute sp_repldone to mark those large transaction as distributed however I can't figure out the page and row id for the parameter. I had to use page and row (instead of xactid and xact_seqno) because my publisher is sql 6.5.
Executing sp_repltrans or sp_replcmds (to find page and row) will hung my server, may be because syslogs is too large-- 175000000+.
Is there another way to find out the page and row id of a transaction? I can find out the xactid from syslogs but that's not gonna help me.
I can reset all transactions as distributed but if possible I don't want to do that. I only want specific transactions to be set distributed.
I would appreciate any suggestions.
Thanks!
Andel
Andel
andel@barroga.net