• I believe that select into is a non-logged operation. Of course if you do a select into or bcp, you're breaking the transaction chain, so you'll have to do a full dump.