Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    108

    Unanswered: [How do I...?] append data without logging?

    Hello. We are using SQL SErver 2000.

    We are moving appending data from one table to another table. Many millions of records.

    We don't have alot of extra log space. How would I do this without it writing to the log files?

    `Le

  2. #2
    Join Date
    Dec 2002
    Location
    Sunny Florida
    Posts
    121
    You can't turn off loging completley. Or at least in 2k you couldn't years ago my boss insisted you could and I hounded MS for proof that there was no way to completley shut it off.

    I don't know how you are getting this data in but perhaps a combination of set implicit transactions on, and commits after a specific number of rows would be of help. I do a lot of this in Oracle.

Posting Permissions

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