disable transaction logging

Hi,

We have a DW project where I would like to disable the transaction logging. Any good advices anyone?

Hello Larra,

You cannot disable the transaction log.

However you can set the database in a read only modus.

No data modifications can be made in read only modus.

The database will also not have any locks on statements, so performance can increase in a reporting environment.

You can set the database in read only mode by using the following statement:

sp_dboption dbname,read only,true

or by altering the database

alter database dbname set read_only statement.

If you have any further questions............................

|||

i am not sure i got the requirement correctly or not... still , here is my comment. SQL Server uses write ahead architecture. That means, before write into Data file , it writes to log first. So , you requirement is to disable this trasaction log entry and directly enter into datafile. If this is your requirement , IT IS NOT POSSIBLE. Any transaction has to log in the TL ,before writing into Data file, you can not bypass TL(Transaction Log). But one thing you can do ; you can make the trasaction minimally logged by keeping Bulk Recovery Model and using BCP or Bulk insert. I hope this will help u

Madhu