it is possible to turn off Transaction Log growth in SQL Server 2008 R2? The problem is that we have low disk space. And i need Load big table, which have a lot of columns and almost on all are indexes. So load is failing because of transaction Log. O set
recovery model to Simple.
I think only about one solution.
1) Drop all indexes on destination table.
2) Load data to table.
3) Recreate indexes.
I noticed, that when i load data to table which hasn't any indexes transaction log isn't growing.
Any other ideas?
View Complete Post