I want to clear the whole transaction log and sql server log...ie., just clear all the entires....how
Printable View
I want to clear the whole transaction log and sql server log...ie., just clear all the entires....how
I useG 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 queryVB Code:
DUMP TRANSACTION [imoReconcile] WITH NO_LOGyou transaction log should be virtually emptyVB Code:
DUMP TRANSACTION [imoReconcile] WITH NO_LOG