Post reply

non logging operations

  • November 4, 2002 at 7:00 am

    #58408

    Besides some of the non-logged functions in SQL server is there any way to turn logging off at startup or other configuration?

    In Oracle and Informix there is a way to specify certain tables and index or engines to not log any events.

    -JG


    -JG

  • November 4, 2002 at 8:03 am

    #440211

    SQL Server needs to maintain the transaction log to support transaction integrity, so you can just turn it off.

    Basically you can set the recovery mode by database to simple, this will not turn off logging, but will minimize the amount of information stored in the log.

    Gregory Larsen, DBA

    If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

    Gregory A. Larsen, MVP

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

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