MS SQL and transaction log

[EmperorIQ]

From what I understand there is a transation log type of database in MS SQL where any changes to your database is stored in there incase you want a back up of some sort. Is there a way to turn this logging off? like some sort of command that says SET TRANSACLOG OFF; /* do something */ SET TRANSACLOG ON;


is there anything like that?

Thanks,

 

[MrChad]

As far as I know, there is no way to disable the transaction log. You wouldn't want to anyway. It's necessary for SQL server to properly handle database transactions (commit, rollback).

 

[EmperorIQ]

thanks for the reply