• you could also increase the growth factor for the transaction log, in the database properties, and change it to unrestricted growth. If it manages to grow large enough without causing a problem to the normal deletes/dataloads you do, then keep the log at that size and reduce the growth factor back to a smaller percentage again (eg 10%). It depends on whether you have the disk space to have the log file as big as it needs to be (to do your transactions in one hit). If not, your only choice is to reduce the number of records you process each time.

    Regards

    Peter