Re: Inserting into a table without logging - SQL Server 2005

Hi,

No, You cant do that. Even in SIMPLE recovery model the transaction will be
logged and cleared during checkpoint. The best way for you is
change the recovery to SIMPLE and insert the records in batches. After the
data load change the recovery model to FULL and perform
a full database backup to reclaim the backup chain.

Thanks
Hari


"spoons" <spoons@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D43AB567-3ECE-4A7D-AB63-64E65FB40184@xxxxxxxxxxxxxxxx
I would like to insert into a table millions of rows without logging the
activity. Can this be done without changing the setting for the database?
I
do not want logging just for that transaction.


.

Relevant Pages

  • RE: Cannot shrink Transaction Log
    ... If you are using Full recovery model then you need to backup the transaction ... > the transaction logs have filled all available disk space. ...
    (microsoft.public.sqlserver.server)
  • Re: Truncate and Shrink
    ... Before I did I BACKUP LOG ... ... The Recovery model is set to as "Full". ... Transaction Backup is set after ... >Did you run DBCC OPENTRAN? ...
    (microsoft.public.sqlserver.server)
  • =?Utf-8?Q?Re:_Gr=C3=B6sse__von_Transaction_Logs?=
    ... Ich habe eine Datenbank mit Recovery Model - Simple. ... Datenbank und Transaction Log haben Autogrowth 10 % - unrestricted. ...
    (microsoft.public.de.sqlserver)
  • Re: non logged transactions with transactional replication
    ... bulk-logged recovery model), you will have to reinitialize. ... transaction does not write everything to the tran log. ... With respect to replication, a minimally logged ...
    (microsoft.public.sqlserver.replication)
  • Re: transaction log blow up
    ... It could be a long running transaction. ... already written to the disk (inactive portion of the log) and you did not ... perfom BACKUP LOG which does truncate this portion so the log will keep on ... I am certain that even though the log file is in SIMPLE recovery model it ...
    (microsoft.public.sqlserver.server)