Post reply

BCP

  • August 12, 2008 at 10:57 pm

    #123018

    Hi Experts ,

    Am using BCP to import more than 100 million records and as a result the log file is growing very large.Is there any option to minimally log in BCP .I have set my recovery model to bulk logged..

    TIA

  • August 12, 2008 at 11:09 pm

    #857177

    are you using the -b flag? if not you should be. otherwise, the entire insert gets committed as a single transaction, which will blow the log file.

    use something like -b100000 and you should be fine. this will commit 100000 rows at a time.

    ---------------------------------------
    elsasoft.org

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

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