Home Forums SQL Server 2005 SQL Server 2005 General Discussion Inserting a 800 million records from Staging database to EDW, how to totally disable logging RE: Inserting a 800 million records from Staging database to EDW, how to totally disable logging

  • April 14, 2010 at 8:07 am

    #1151366

    PaulB-TheOneAndOnly (4/14/2010)

    chris.stuart (4/3/2009)

    4) I would also like to set the logging db to maybe just a few gigs with the space being reused and records being committed as and when needed, but I keep on running into (The transaction log for database is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases) error.

    lots of questions and I suffer from ADD syndrome so... let me answer the last one 😀

    Use small transaction size a.k.a. run your load in small batches.

    I certainly would recommend small batches.


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]