Originally posted by: Pro Pete
Deleting rows in smaller chunks will only help with Log size issue if database in Simple recovery model or Log Backup performed between chunks.
Even if you are in FULL recovery, during maintenance period you can flip over to Simple, do your deletes, and flip back to FULL. Obviously you can't do mirroring or log-shipping during this period.
Alternative to deleting: Add IsActive flag to table(s). Delete periodically (like year-end) based on flag. Actually this solution will speed up db operations because delete can be real slow.
Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQL Server 2005 Training, SSAS, SSIS, SSRS: http://www.sqlusa.com/