Home Forums SQL Server 2005 Backups Best Practice Advice on Trans Logs, how to automate RE: Best Practice Advice on Trans Logs, how to automate

  • I have read thru the Managing Transact Logs document but was kind of wanting some practical information. Like is the accepted practice to monitor transaction log files regularly and if they get to big, run a checkpoint and shrinkfile on the log file. (simple recovery)

    Thanks