Month: February 2013

SELECT file_id, name FROM sys.database_files BACKUP LOG [databaseName] TO DISK=‘nul:’ WITH STATS= 10 DBCC SHRINKFILE(‘templog’, 0, TRUNCATEONLY)