Transaction Logs

  • Hi

    New to SQL Server Database. Can anyone help me to disable the transaction logs settings in the Database.

    Regards

    Chandu

  • What settings are you referring to?

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • Is it posssible to run the Database with out Transaction logs?.... In case of recovery, I will be recovering till the last backup.

    quote:


    What settings are you referring to?

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)


  • Sorry no you cannot turn off using a transaction log.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • you can run in simple more, which will truncate the log and essentially work without one, but some things will still be logged.

    Steve Jones

    steve@dkranch.net

  • Thanks Steve. I was looking for the same option...

    quote:


    you can run in simple more, which will truncate the log and essentially work without one, but some things will still be logged.

    Steve Jones

    steve@dkranch.net


Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply