I'm trying to load A LOT of data to a table, -- about 64million records. The load process itself will take hours to run and every time I tried it, I got "log is full" error. I've set the max size to 80G now for the transaction log. I also
scheduled a job to run every 10 mins to shrink the log file. But it doesn't help at all. Here are my questions:
1. how to estimate the max size of the log file? I don't want it to grow unlimited.
2. how to keep the log file as small as possible during the load process? It'll be the best to me if it can be turned off. Because I don't need the transaction log at all.
Please help. It's pretty urgent as I'm very frustrated because of this log issue. I've tried many times, and the job failed every time. I'm getting nowhere.
View Complete Post