Archive for 'SQL'

Truncating Transaction Logs in SQL 2008

Posted on 29. Jan, 2010 by bryan.

0

One of my clients is beginning to migrate to SQL 2008 for their SharePoint farms.  In the past, we have used scripts to truncate the transaction logs and shrink the DBs in the non-production environments using the “BACKUP LOG [dbname] WITH TRUNCATE_ONLY” command.  As you may be aware, the “WITH TRUNCATE_ONLY” option has been deprecated [...]

Continue Reading