• Grumpy DBA (5/24/2016)


    Base the log backup frequency on the amount of data your business user can afford to lose.

    This. If the database just does one ETL job daily and is not transactionally active after that, then perhaps one log backup daily is OK. This is not a common mode of operation, but maybe it is what you're doing. If the database is active, then having a once a day log backup is an invitation to disaster and potentially an RGE (resume-generating event, i.e., you're out looking for a new job).

    How big is the database and the log? And is it active? Brent Ozar[/url] has recommended doing log backups EVERY MINUTE. I consider this slightly excessive, but it does have some good reasoning behind it.

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]