Sachin Nandanwar (12/3/2010)
Also it is a better idea to put the recover model to SIMPLE or else your log file will bloat.But make sure you take a Full and a T log backup before changing the recovery model to SIMPLE.
Agh... be careful now. Changing to SIMPLE breaks the backup chain. This is normally one of the worst things you can do.
--Jeff Moden
Change is inevitable... Change for the better is not.