Since migrating from SQL 2005 to 2008 the transaction log has grown significantly as the FTC is stored within the database and its activity is logged by the DB engine.
We've put the fulltext index into "manual" tracking mode rather than "auto" which prevents the automatic and unpredictable master merges and scheduling regular update populations. However for a 280Gb FTC its is filling our 500Gb transaction log.
Trying to truncate the log isn't working indicating that the FTS is trying to comlpete a single large transaction.
Any ideas on how we could tackle this problem?