Greetings Everyone,<br><br>     I am faced with the challenge of opting for either simple or full recover model. I have read on sites that Full mode is much safer when a Database failure occurs essentially because transaction log files are maintained. Unlike simple mode, which allows you to shrink log files and incase of a Database failure or DB is corrupted then you will have to rely on your last Database backup.<br>
<br>    I welcome your views on how you tackle this since on my side I would like  to keep the transaction log files size very small i.e less than 100MB. Note that the Database log files in question keeps on growing rapidly.<br>
<br>Kind Regards,<br>Emmanuel.<br>