What is the command to truncate a SQL Server log file?

In management studio:

Don't do this on a live environment, but to ensure you shrink your dev db as much as you can:
- Right-click the database, choose Properties, then Options.
- Make sure "Recovery model" is set to "Simple", not "Full"
- Click OK
Right-click the database again, choose Tasks -> Shrink -> Files
Change file type to "Log"
Click OK.

Alternatively, the SQL to do it:

 ALTER DATABASE mydatabase SET RECOVERY SIMPLE DBCC SHRINKFILE (mydatabase_Log, 1)

sql-server truncate logging

if I remember well... in query analyzer or equivalent:

BACKUP LOG  databasename  WITH TRUNCATE_ONLYDBCC SHRINKFILE (  databasename_Log, 1)

sql-server truncate logging

For SQL Server 2008, the command is:

ALTER DATABASE ExampleDB SET RECOVERY SIMPLEDBCC SHRINKFILE('ExampleDB_log', 0, TRUNCATEONLY)ALTER DATABASE ExampleDB SET RECOVERY FULL

This reduced my 14GB log file down to 1MB.

CodeHunter