Home Forums SQL Server 2005 Administering Is there any way t automate the auto shrink the transaction logs RE: Is there any way t automate the auto shrink the transaction logs

  • if you don't need point in time recovery set your recovery mode to simple, else schedule regular transaction log backups, that will prevent the log growth.

    There is NO need to repeatedly shrink the log if you do the above.

    ---------------------------------------------------------------------