Comments and notes on SQL Server 2000, 2005, and T-SQL
Code to compact (truncate) SQL logs
backup log myDatabaseName with truncate_only
DBCC SHRINKDATABASE (myDatabaseName,10)
About Steve Gray
Steve is a seasoned (translate: old) developer in VB and ASP.NET. He spends most of his time in Dynamics GP, writing custom mods for consulting firms. Crystal reports, eConnect, VS Tools for Dynamics... anything that comes along.