Friday, February 24, 2012

[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?
`LeYou 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.

No comments:

Post a Comment