I retired from personal blogging in July 2008 but you can find me over at blog.xero.com

Truncate Log Scripts
Posted by rod@drury.net.nz in Old-blog-archives at 3:24 pm on Tuesday, 29 November 2005

For my own reference, this TSQL script shrinks the database logs.

DECLARE @DB varchar(100)
SET @DB = DB_NAME()
BACKUP LOG @DB WITH TRUNCATE_ONLY
DBCC SHRINKDATABASE (@DB, TRUNCATEONLY )

Trackback uri |