• You can't do any and modification in the database without logging. Logging is essential for the database. Without it the server won't be able to rollback any statement. If you don't want the log to grow so much you can do the fallowing things:

    If you delete the whole table and there is no replication and other tables don't reference your table with a foreign key, then you can truncate the table instead of running the delete statement. This will still be logged, but it will log the modification in the table's pages allocation and not every record that was deleted.

    If you delete many records, you should delete it in chunks and not all the records in one statement. If your database is in full recovery or bulk logged model you can do logs backup between the chunks (not between each one of them, but after each X chunks. You'll have to work out yourself when to do it). If the database is in simple recovery model, you don't have (and can't) do the log backup.

    Adi

    --------------------------------------------------------------
    To know how to ask questions and increase the chances of getting asnwers:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/