Timeline for Why does my transaction log use so much space?
Current License: CC BY-SA 3.0
3 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Nov 16, 2012 at 13:44 | comment | added | mike42 | Terrific advice! I mocked up a test and reran the exact same process, exact same data, exact same tables. The insert took 20 seconds rather than 20 minutes. Log space usage was much less (I was unable to monitor the log space as precisely due to the single user mode). The only thing I did differently was to use simple recovery mode rather than bulk. | |
Nov 16, 2012 at 13:41 | vote | accept | mike42 | ||
Nov 15, 2012 at 3:33 | history | answered | Bacon Bits | CC BY-SA 3.0 |