Thursday, January 15, 2009

truncate sql server transactional log withou backcup

sometimes on fire and the risk to truncate sql server without backup up.

backup log with TURNCATE_ONLY;

it works on sql server 2000.

but looks no more supported on 2008 . no time to check 2005 ..