Truncate Log File and Pending Replication

http://www.ureader.com/msg/11604551.aspx

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_23370017.html

ERROR MESSAGE: "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."



SOLUTION:







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





ERROR MESSAGE:





"Msg 18757, Level 16, State 1, Procedure sp_repldone, Line 1 The database is 





not published."





SOLUTION:







sp_dboption 'databasename'



GO



EXEC sp_dboption 'DatabaseName', 'Publish', 'true'



GO



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



ERROR MESSAGE:

use


 [database]



go



exec


 sp_repldone @xactid = NULL


, @xact_seqno = NULL


, @numtrans = 0, @time = 0, @reset = 1

With success being confirmed via the following check:

use


 [distribution]



go



exec


 sp_browsereplcmds



The check still returns rows, which I take to mean that the queue isn't



clear. Is there something else that needs to be done here to



completely clear the queue? 





SOLUTION:







issue the call to DBCC OPENTRAN in the Publication database.



Look for the value of Oldest non-distributed LSN.




if the value is  : (0:0:0) 


 then the log reader agent is all caught up.




ERROR MESSAGE:





Log Reader Error: The process could not execute 'sp_repldone/sp_replcounters'



SOLUTION:  

sp_replrestart