SQL Server 2005 SP4 with Transactional replication.
I have this Database Log, which keeps growing due to a Pending transaction in the Database Log. (DB in SIMPLE recovery Mode)
If i issue a DBCC OPENTRAN i get :
Replicated Transaction Information:
Oldest distributed LSN : (0:0:0)
Oldest non-distributed LSN : (47839439:351:1)
The following Query using fn_dblog gives me LSN and Transaction ID Info.
select * from::fn_dblog(NULL,'47839439:351:1')
If i have to Shrink the Log i have to use sp_repldone to mark the transactions as replicated or skipped.
I take precautions in running this statement as this is not always what you want to do manually as it is internally done by the Log Reader Agent.
EXEC sp_repldone @xactid = NULL, @xact_segno = NULL, @numtrans = 0, @time = 0, @reset=1
Now.. What if i Just want to mark just the transaction in question as done.. using the @xactid
How can i translate the CurrentLSN or TransactionID or LogRecord or Transaction SID or any other vlue to--> @xactid.....