Brandie Tarvin (3/17/2010)
Understand that minimum logging is different than "no" logging. You might want to change the Recovery mode to Bulk-Logged instead of Simple (unless the db is already set to Simple) before doing your delete. This way, if you need to recover, you'll still have a transaction log to recover from.
Deletes are always fully logged (truncate table excepted, which is always 'minimally logged' - sort of) regardless of the recovery model.
Changing from simple recovery also changes nothing until a full backup is taken to establish a base for a future restore.
The log stays in auto-truncate mode until the first full backup after a change from simple recovery.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi