Code to compact (truncate) SQL logs
backup log myDatabaseName with truncate_only DBCC SHRINKDATABASE (myDatabaseName,10)