Hi Matthew,

Here is the command you need to run to carry out Ian's suggestion.

backup log <DB Name Here> with truncate_only

After this, you need to consider the backup solution you require for this db, then set the database recovery mode as Ian suggests.

Best regards,

Martin