• 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 in SQL 2008.

    The deprecated queries (which are supported in SQL 2000 and SQL 2005, but no longer supported in SQL 2008) are as follows:

    --To truncate the log file

    backup tran <dbname> with no_log

    --To Shrink the T-log container:

    dbcc shrinkfile(<dbname>empty_log)

    The only way to keep the Transaction log small, is to do incremental backups (multiple times during the day) of the transaction logs.