I have some processes that work on 100's of thousands of records daily. What they do is important but only parts of the processes are done in a way that needs logging. So, instead of filling my transaction log with all of these events and requiring a large transaction log, I would rather ignore some of the process.
One thing I have done is use the truncate command to delete all the records in a temp table. It helps but I want to reduce the logging even more. Oh yeah, I'm also a bit of a freak. :-\ On 2/1/06, Jim Wright <[EMAIL PROTECTED]> wrote: > There are certain operations with the bcp utility which can be minimally > logged, but I don't know of any way to not log general database > activity....it kind of defeats the purpose of having the transaction log. > Why would you want to do that? > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231104 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
