Sunday, February 19, 2012

Delete records without logging

Hello,
I have one table that has 59 million records now i need to delete part of
this table (near 55million records)
Is it possible to do this operation without being logged anything in the
transaction log?
When i try to perform my delete, *.ldf starts growing and the operation
stops since i only have 300MB available in the drive.
Thanks and best regardsBCP out the 5Million rows that you want to keep and then truncate the table
and BCP them back in. Otherwise you should delete in small batches of say
10 to 100 thousand at a time.
Andrew J. Kelly SQL MVP
"CC&JM" <CCJM@.discussions.microsoft.com> wrote in message
news:CBDC02AB-DC72-4653-A2CD-53B3C32076F2@.microsoft.com...
> Hello,
> I have one table that has 59 million records now i need to delete part of
> this table (near 55million records)
> Is it possible to do this operation without being logged anything in the
> transaction log?
> When i try to perform my delete, *.ldf starts growing and the operation
> stops since i only have 300MB available in the drive.
> Thanks and best regards

No comments:

Post a Comment