Can I turn SQL Server logging off?

Neil Pike

March 4, 1999

1 Min Read
ITPro Today logo

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.

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like