Hi Emmanuel, I hope you are doing well. sbungei can assist you with this challenge, I suggest you contact him off-list? On Wed, Nov 10, 2010 at 10:33 AM, Emmanuel Ochieng < emmanuelochieng797@gmail.com> wrote:
Greetings Everyone,
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.
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.
Kind Regards, Emmanuel.
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke