How to clear the logs

[jag_chat]

I want to clear the whole transaction log and sql server log...ie., just clear all the entires....how

[wes271]

I use

DUMP TRANSACTION [imoReconcile] WITH NO_LOG

G in the query analyzer to clear out my transaction log. but first you must back up the data file as well as the transaction log. after you run this query

DUMP TRANSACTION [imoReconcile] WITH NO_LOG

you transaction log should be virtually empty