September 6, 2011 at 10:06 am
Can't turn off the logs (as in impossible)
Even in simple mode the logs will get full.
As I said you can add another log file on another drive where you have more room and you should be fine.
I like the sliding window approach, but I'm afraid you'd run of of space just as quickly unless the data files have a tone of free space.
September 6, 2011 at 10:08 am
There's not way to turn off the transaction log, but if you're using the batching idea that I proposed above then you could try setting to SIMPLE recovery mode so that the transaction log gets truncated after each checkpoint. To be honest, I wouldn't recommend that, since you'll break your backup chain.
--edit--
Bah, echo'd the post above me.
September 6, 2011 at 10:10 am
Cadavre (9/6/2011)
There's not way to turn off the transaction log, but if you're using the batching idea that I proposed above then you could try setting to SIMPLE recovery mode so that the transaction log gets truncated after each checkpoint. To be honest, I wouldn't recommend that, since you'll break your backup chain.--edit--
Bah, echo'd the post above me.
.... and you'll still run out of space because you still have 2.X times the base table. :hehe:
September 6, 2011 at 10:12 am
Ninja's_RGR'us (9/6/2011)
Cadavre (9/6/2011)
There's not way to turn off the transaction log, but if you're using the batching idea that I proposed above then you could try setting to SIMPLE recovery mode so that the transaction log gets truncated after each checkpoint. To be honest, I wouldn't recommend that, since you'll break your backup chain.--edit--
Bah, echo'd the post above me.
.... and you'll still run out of space because you still have 2.X times the base table. :hehe:
Quite probably 😀
But I'm hoping that the log files and the data files are on different drives, with more space available to the data
Viewing 4 posts - 16 through 19 (of 19 total)
You must be logged in to reply to this topic. Login to reply