Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Delete statement without transaction log

Author  Topic 

t2tviking
Starting Member

1 Post

Posted - 2007-08-27 : 09:05:44
Hello,

I'm going to delete millions of historic records based on a datetime-criteria (can't use truncate as I must keep the relevant live data in the table) and was hoping there was a (easy) way to do this without generating gigabytes of transaction log?



Best regards,

Kjetil Johannesen,
Norway

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-08-27 : 09:08:08
Delete in smaller chunks.

First of all, there is a great FAQ here
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210

Great examples found here
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=77084

and here
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=83525


E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page
   

- Advertisement -