If my recovery model is BULK LOGGED, I'm in a transaction, and I've issued some statements that are minimally logged like SELECT * INTO, will a ROLLBACK undo those minimally logged statements?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
I decided asking here was just being ultra-lazy so tested it myself.
This shows that the rollback does remove the table tmp_test and the row from tmp_test2, so the answer is that minimally logged operations are still rolled back.
Hmm... so how come using them prevents the transaction log from getting really big?