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
  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
  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.
  4. mssql_dba_123 New Member

    Change the db in full recovery model.
  5. Ali K. New Member

    Guys, My recovery model is full but still disabled.
    Plz Help.
    Ali
  6. miteshaegis New Member

    Hi,

    XLA monitors log records. A log record describes an insert, update or delete on a row in a table.
  7. Luis Martin Moderator

    Kindly start a new tread. This one is 4 years old.

Share This Page