Home Forums SQL Server 2005 Administering Log file growing on principal server--log backups scheduled every 2 hrs. RE: Log file growing on principal server--log backups scheduled every 2 hrs.

  • January 31, 2013 at 10:00 pm

    #1583260

    Looks to me that you may need to run your log backups more frequently than every two hours.

    You may also have a problem with many small VLF's. Not sure how to show this, but I'm sure someone else can help with that.