Hi Emmanuel, I hope you are doing well. <div><br></div><div>sbungei can assist you with this challenge, I suggest you contact him off-list?<br><br>
<br><br><div class="gmail_quote">On Wed, Nov 10, 2010 at 10:33 AM, Emmanuel Ochieng <span dir="ltr">&lt;<a href="mailto:emmanuelochieng797@gmail.com">emmanuelochieng797@gmail.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">

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><font color="#888888">Emmanuel.<br>
</font><br>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke">Skunkworks@lists.my.co.ke</a><br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></blockquote></div><br></div>