Please note: 8 year old thread, and the linked page just says to run repair (well, and buy some magic software), which the OP had already tried.

Searching for the XML tags won't get you anywhere, because those get generated from data, they're not hard coded into the procedure. Instead, look for procedures that are generating XML...

Are the log backups being done with no_truncate or copy_only options?

If you run a checkpoint after the log backup, what does the log_reuse_wait change to (it shows the...

For those mentioning index maintenance, queries, etc, the OP's asking about partitions of Analysis Services cubes, not SQL Server tables. Very different beasts.

No idea. How busy are each of them? How much data do they work with?

Run the alter database,...

That doesn't sound like mirroring or availability groups, as they are high-availability solutions that can allow for reading from secondaries as a bonus.

This sounds like a problem that...