SQL Server Performance

Avoid transaction log

Discussion in 'SQL Server 2005 General DBA Questions' started by AJITH123, Mar 17, 2010.

  1. AJITH123 Member

    Hi Guys,
    Is it possible disble the transaction log for the dml stament for table? OR how can we avoid loging the data while creating the table? We do not want to change the database recovery model as simple.
    AJITH123, Mar 17, 2010
    #2

  2. FrankKalis Moderator

    Are you asking for DML statements or DDL statements? Creating a table via CREATE TABLE... would fall under the DDL category. Why don't you want table creation statements to be logged?
    You can't disable the t-log altogether. It is an integral part of SQL Server.
    FrankKalis, Mar 17, 2010
    #3

  3. AJITH123 Member

    No, i did not asked for DDL statement. I asked for insert, delete, update statement in a table. I do not want to log those transaction. Is it possible?
    AJITH123, Mar 17, 2010
    #4

  4. FrankKalis Moderator

    No, that is not possible. INSERT, UPDATE & DELETE statement are always logged (either fully or minimally), regardless of the recovery model. However, you might want to check the chapter "Best Practices for Bulk Loading Data" here: http://msdn.microsoft.com/en-us/library/ms174335.aspx
    FrankKalis, Mar 17, 2010
    #5

  5. AJITH123 Member

    Thank you!
    AJITH123, Mar 17, 2010
    #6

  6. satya Moderator

    Ajith
    Its like nothing but asking your heart not to pump while you are breathing...imagine, so Transaction log is like that for a DB. You can control the logging by reducing the recovery model methods.
    satya, Mar 24, 2010
    #7

  7. thewebhosting New Member

    Hi,
    It is not possible to disable the Transaction logs. You can set auto shrink the logs features so you may not face any issue of log file full and writing to database problem.
    thewebhosting, Mar 20, 2010
    #8

Share This Page