SQL Server Performance

Transaction Log file Backup

Discussion in 'SQL Server 2005 General DBA Questions' started by y.koteswarrao, Nov 7, 2008.

  1. y.koteswarrao New Member

    Hi DBA guru's
    iam unable to back up the transaction log, because it is in disable state,how to enable the transaction log?
    Koteswar rao.Y
    y.koteswarrao, Nov 7, 2008
    #2

  2. Elisabeth Redei New Member

    Hi,
    How do you mean disabled? What does the following queries return:
    SELECT type, name, state, state_desc FROM sys.database_files
    GOSELECT
    name, database_id, state, state_desc, recovery_model FROM sys.databasesWHERE
    database_id = db_id()
    /Elisabeth
    Elisabeth Redei, Nov 7, 2008
    #3

  3. rohit2900 Member

    Can you cross check whether you db is in full or bulk logged recovery mode. As you cannot take transaction log backups in simple recovery mode.
    rohit2900, Nov 12, 2008
    #4

  4. mssql_dba_123 New Member

    Change the db in full recovery model.
    mssql_dba_123, Nov 17, 2008
    #5

  5. Ali K. New Member

    Guys, My recovery model is full but still disabled.
    Plz Help.
    Ali
    Ali K., Oct 10, 2012
    #5

  6. miteshaegis New Member

    Hi,

    XLA monitors log records. A log record describes an insert, update or delete on a row in a table.
    miteshaegis, Nov 30, 2012
    #6

  7. Luis Martin Moderator

    Kindly start a new tread. This one is 4 years old.
    Luis Martin, Nov 30, 2012
    #7

Share This Page