Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Re: Turn Off Transaction Log for Insert
204 views
Skip to first unread message
Anith Sen
Apr 27, 2004, 10:20:29 AM4/27/04
to
No, you cannot turn of transaction logging. However you can use minimally
logged methods like SELECT INTO ... for such requirements.
logged methods like SELECT INTO ... for such requirements.
--
Anith
Tibor Karaszi
Apr 27, 2004, 10:19:34 AM4/27/04
to
Not generally as transaction logging is an integral part of SQL Server (used in many places and situations).
Some operations can go minimally logged, like different types of "bulk imports" (BCP, BULK INSERT, DTS etc).
Some operations can go minimally logged, like different types of "bulk imports" (BCP, BULK INSERT, DTS etc).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"James Nadile" <jna...@praxinet.com> wrote in message
news:9B2AE0F2-E3ED-4A2B...@microsoft.com...
> Just wondering how i would Turn off the Transaction Log for a log process i need to run in Query analyzier,
which need to insert about 10 million rows.
>
> Is there like a
> Set TRANSACTION_LOG OFF??????
Eric Sabine
Apr 27, 2004, 10:20:05 AM4/27/04
to
Sorry, can't turn off logging completely but you can do a minimal logged
bulk copy. Please look at "minimally logged bulk copy" in the BOL
bulk copy. Please look at "minimally logged bulk copy" in the BOL
hth
Eric
James Wilson
Apr 27, 2004, 10:48:57 AM4/27/04
to
James Nadile wrote:
> Just wondering how i would Turn off the Transaction Log for a log process i need to run in Query analyzier, which need to insert about 10 million rows.
>
> Is there like a
> Set TRANSACTION_LOG OFF??????
> Just wondering how i would Turn off the Transaction Log for a log process i need to run in Query analyzier, which need to insert about 10 million rows.
>
> Is there like a
> Set TRANSACTION_LOG OFF??????
Hi Nadile,
You cannot turn Transaction Logging off in MS SQL Server. What could
use is a Bulk Insert statement or bcp instead. Search BOL for "logged
and minimally logged bulk copy operations".
James
Rand Boyd [MSFT]
Apr 27, 2004, 10:55:38 AM4/27/04
to
You cannot turn off transaction inserts. If you can use DTS or BCP to
perform the insert then you can set the batch size to minimize the effects
on the log, depending on the recovery model you are using.
perform the insert then you can set the batch size to minimize the effects
on the log, depending on the recovery model you are using.
Rand
This posting is provided "as is" with no warranties and confers no rights.
anon...@discussions.microsoft.com
Apr 27, 2004, 11:51:28 AM4/27/04
to
You can change your database log method to bulk insert
>-----Original Message-----
>Just wondering how i would Turn off the Transaction Log
for a log process i need to run in Query analyzier, which
need to insert about 10 million rows.
>
>Is there like a
>Set TRANSACTION_LOG OFF??????
>.
>
>-----Original Message-----
>Just wondering how i would Turn off the Transaction Log
for a log process i need to run in Query analyzier, which
need to insert about 10 million rows.
>
>Is there like a
>Set TRANSACTION_LOG OFF??????
>
0 new messages