November 25, 2003 at 3:58 pm
Is there any way to turn off Transaction Logging for a INSERT INTO statement?
I know that SELECT INTO / BCP can have logging turned off, but our apps do a lot of
INSERT INTO from one database to other and wondering if I can turn off loggin of those.
thanks.
November 25, 2003 at 5:17 pm
no
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 26, 2003 at 2:09 am
The only way to reduce the logging is to do a bulk insert/bcp and having the bulk logged recovery option set.
I now it is not handy but this is the only way.
Every DML operation MUST be logged otherwise in case of failure you won't be able to recover your database.
Shortly, as Steve told you, there is no way to switch off the log
Bye
Gabor
Bye
Gabor
November 26, 2003 at 6:09 am
You could also try Truncate Log on Checkpoint in SQL 7 or Simple recovery in 2000. Logging will still occurr but logs will truncate periodically keeping it small.
November 26, 2003 at 9:02 am
If the insert is large, perhaps it can be broken up into several inserts to keep the transaction size reasonable.
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply