Viewing 2 posts - 1 through 2 (of 2 total)
The most efficient way to keep the log files from growing, is to do "Incremental" T-log backups (multiple times throughout the day.)
December 4, 2009 at 3:24 pm
#1088068
Another major gotcha for SQL 2008 is the fact that you can no longer truncate and or shrink your database transaction logs. The queries to perform this task are deprecated...
December 4, 2009 at 2:18 pm
#1088046