• In general, a database should be in full backup mode for precisely the reasons described here. There are advantages to using the Simple backup model.

    The prime one being less concern about the transaction log growing or worry about them filling up. They can still grow of course (assuming autogrowth is on) in simple, but this will be a less frequent event under normal usage patterns using simple than using full, and there is no need to trake the time to truncate those logs.

    Also, certain types of transactions are generally faster under a simple model.

    ---
    Timothy A Wiseman
    SQL Blog: http://timothyawiseman.wordpress.com/