Post reply

Select into & Full/ Bulk Recovery Model

  • March 7, 2003 at 1:33 am

    #80844

    Can anyone confirm whether using 'select into' invalidates the transaction log ?

    I have piece of text that says using 'full' recovery gets round this problem, while another that says select into should not be used as it invalidates the transaction log.

    Please clarify

  • March 7, 2003 at 2:20 am

    #450499

    My understanding is that "Full Recovery" records absolutely everything and is granular.

    My understanding is that Bulk logging is used for massive inserts into the database.

    I've had a situation where Full Logging resulted in my disk filling up because all the inserts got recorded as separate transactions.

    The select into bulk copy options exists precisely to alleviate this situation.

    You should back-up your database before running a bulk copy and back up the database afterwards because bulk copies are not recorded in the transaction log.

    LinkedIn Profile

  • March 7, 2003 at 2:21 am

    #450500

    Thanks very much

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply