Can I turn SQL Server logging off?

A. The short answer is no. It is an integral part of the SQL systemand cannot be turned off.

Certain operations are "non-logged" like fast-BCP and select into.This means they do not log record updates. However they DO log extentallocations. They need to do this so that if the process is terminatedunexpectedly (maybe the power goes out), SQL can recover the space. Thisgreatly reduced logging can result in better performance - but as it makes thedatabase non-recoverable from transaction-logs should be used with caution.