Switch off transactional logs

[Former Member]

Hi,

How can i switch of the transactional logs in MSSQL.

please it is urgent.

Urgent...

Full points.

vinnu.

[clas_hortien]

Hello,

you cannot switch off the transaction log completely. Even when you set the database into simple recovery mode, the transaction log is used. The difference is that in simple mode the transactionlog gets truncated when the transaction gets commited or rolled back. So the transaction log will fill up the size of the transaction changes.

To set the database into simple mode run:

alter database <DBName> set recovery simple

When you set the DB into simple mode you will break your transactionlog backup chain, so that you when you switch back to full mode you have to run a complete database backup.

Best regards

Clas

[Former Member]

Just switch to the Recovery Model 'Simple' (Enterprise Manager or Managemant Studio). But why would you want to do that?

Regards,

Sven