troubleshooting Question

sp_repldone to marked the replication dirtibuted but how to repblish the data?

Avatar of motioneye
motioneyeFlag for Singapore asked on
Microsoft SQL Server 2005
9 Comments3 Solutions1007 ViewsLast Modified:
I'm running out of space with Tlog and the only way that can I reduce the Tlog is  mark all the pending transaction as marked, so that I run a below commands

the pending replication before run sp_repldone
database                                                                                                                         replicated transactions replication rate trans/sec replication latency (sec) replbeginlsn           replnextlsn
-------------------------------------------------------------------------------------------------------------------------------- ----------------------- -------------------------- ------------------------- ---------------------- ----------------------
HP                                                                                                                            199936                  0                          0                         0x0000001A000014850001 0x0000001A000014850004

Run the below commands and now its OK but how do I re-replicate all the 190k transaction above at later time

sp_repldone @xactid = NULL, @xact_segno = NULL, @numtrans = 0,     @time = 0, @reset = 1


Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 3 Answers and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros