You will need this option switched on or you'll get an error. So you're
partially right! It doesn't switch off the transaction log, but it will
prevent you dumping the log if you have done a BCP or other non-logged
operation.

Mark.
www.allisonmitchell.com

-----Original Message-----
From: Long, Charles (euler:eti) [mailto:Charles.[Email Address Removed] 25 February 2002 11:48
To: 'Mark.[Email Address Removed] RE: Transaction Log ...


Oh whoops, I've just advised using the select into/bulcopy option; I thought
it did turn logging off.

> -----Original Message-----
> From: Mark.[Email Address Removed] [SMTP:Mark.[Email Address Removed] Sent: Monday, February 25, 2002 11:25 AM
> To: [Email Address Removed] Subject: RE: Transaction Log ...
>
> No, you can't. The only way to do it is to set truncate log on checkpoint
> option on, and then do the load in batches. BCP has a batch size parameter
> to help you do this.
>
> Mark.
> www.allisonmitchell.com
>
> -----Original Message-----
> From: Phil Shuttleworth [mailto:Phil.[Email Address Removed] Sent: 25 February 2002 11:25
> To: Lazydba (E-mail)
> Subject: Transaction Log ...
>
>
> Does anyone know if it is possible to switch off the Transaction log in
> SQL
> Server 7.0, in order to run a massive load program, for example, and if so
> how do you do it?
>
> Phil.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed]
>
> *******
>
> This message and any attachment are confidential and may be privileged or
> otherwise protected from disclosure. If you are not the intended
> recipient, please telephone or email the sender and delete this message
> and any attachment from your system. If you are not the intended
> recipient you must not copy this message or attachment or disclose the
> contents to any other person.
>
> For further information about Clifford Chance please see our website at
> http://www.cliffordchance.com or refer to any Clifford Chance office.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page