all groups > sql server replication > october 2004 >
You're in the

sql server replication

group:

truncate log: error 4215


truncate log: error 4215 tohas NO[at]SPAM freenet.de
10/29/2004 11:29:22 AM
sql server replication:
HI NG,

on a testserver mssql2k I have one publication
with NO subscribers

backup LOG ..
fails:

The log was not truncated because records at the beginning of the log
are pending replication. Ensure the Log Reader Agent is running or use
sp_repldone to mark transactions as distributed.

but
sp_replshowcmds

shows NOTHING

in but in the DB-LOG are stil more than one million of records

I wan't not use:

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

because the replication must be rebuild in this case



I would like to figure out the exact "xactid" to mark only this LSN
for transaction.

How can I find the LSN?

Thanks
Re: truncate log: error 4215 tohas NO[at]SPAM freenet.de
10/29/2004 2:21:26 PM
sorry for the silly question

I figured out in the meantime

AddThis Social Bookmark Button