T-SQL script to delete a whole bunch of records from a table without growing the log. In this example my table has a field called "recordinsertdt" and I'm keeping the most recent 215 days and deleting the rest. Records are deleted 50000 rows at a time.

deleterecords.sql

doOver:
DELETE TOP (50000)
FROM  mytable
WHERE recordinsertdt <=
(
    SELECT DATEADD(day, -215, CAST(GETDATE() AS DATE))
);
IF @@rowcount > 0
    GOTO doOver;