Without a doubt use full recovery. There is peace of mind in being able to recover to any point in time<br><br><div class="gmail_quote">On Wed, Nov 10, 2010 at 2:06 PM, William Warero <span dir="ltr">&lt;<a href="mailto:wwarero@gmail.com">wwarero@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;">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"><div><div></div><div class="h5">On Wed, Nov 10, 2010 at 10:33 AM, Emmanuel Ochieng <span dir="ltr">&lt;<a href="mailto:emmanuelochieng797@gmail.com" target="_blank">emmanuelochieng797@gmail.com</a>&gt;</span> wrote:<br>
</div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div></div><div class="h5">

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></div></div>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke" target="_blank">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>
<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>