We have several tables which we "refresh" frequently by rebuilding them in a staging-table, then performing a metadata-switch to the production-table using the
ALTER TABLE <source> SWITCH INTO <target> statement.
These operations are causing a huge amount of logging, and we're not sure how to handle it. For now we just moved these tables and operations to a new database using the
SIMPLE recovery model, but I would love to hear alternative solutions to this problem.
How do you suggest we handle the massive log generation as a result of frequent table rebuilds?