nazaninahmady_sh (12/23/2008)
sorry what do you mean by non-logged operation?
every action you perfom that changes data or structure of your database is first written to the log file (There are two types of files associated with your database. 1. datafiles- containing actual data, 2. logfiles - all changes to your database are written to log files).
You use logs to recover from a database crash in conjuction with a full backup file.
non-logged operation is something where changes are not logged into the log files.
Minimally logged operation is something where minimum amount of information is written to the log files that is sufficient enough to recover from a crash.
What Gail tried to explain here is DELETE is a fully logged operation where as TRUNCATE is a minimally logged operation.
Full logging and minimal logging also depends on the recovery model that you've set for you database.