Home All Groups Group Topic Archive Search About

Help with Update and logging

Author
28 Jul 2006 9:54 PM
KT
Is there a way to run an update without it increasing the log size.  I have
to do this on 2 million records and log file grows from 6GB to 25GB.

Thanks in advance.

Author
28 Jul 2006 9:58 PM
Tom Moreau
You cannot prevent logging when you are updating.  Consider doing the update
in chunks and backing up the log frequently.

--
   Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON   Canada
..
"KT" <kt***@hotmail.com> wrote in message
news:uDVGfBpsGHA.4444@TK2MSFTNGP06.phx.gbl...
Is there a way to run an update without it increasing the log size.  I have
to do this on 2 million records and log file grows from 6GB to 25GB.

Thanks in advance.

AddThis Social Bookmark Button