Results 1 to 7 of 7
  1. #1
    Join Date
    May 2006
    Posts
    6

    Unanswered: Temporarily disable logging during large inserts?

    I have an application that dumps massive amounts of data into a database during the installation. My log file always ends up being 30-40GB+ at the end of the install. Can I turn off logging while I do the install and enable it after? What are my options.

  2. #2
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    try using bcp.exe instead, and use the -b option.

  3. #3
    Join Date
    May 2006
    Posts
    6
    Quote Originally Posted by jezemine
    try using bcp.exe instead, and use the -b option.
    My application reads data on the fly from an external source and inserts it into a database. Basically we take a massive amount of data from a legacy system, parse it and insert it into a database. A bulk copy is not possible.

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Yes, you can turn off logging during the install. You'll want to turn logging on again following process completion, and then run an immediate full backup to ensure recovery. You also risk losing any other transactional data entered into the system while the process runs, so you should consider restricting access during that time as well.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  5. #5
    Join Date
    May 2006
    Posts
    6
    Where do I disabled it?

  6. #6
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Database properties. Set the database to Simple Recovery Mode.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  7. #7
    Join Date
    May 2006
    Posts
    6
    way ahead of ya Does the trick!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •