SQL Server Performance

Reasons for log backup to fail

Discussion in 'SQL Server Log Shipping' started by ashwinreddy.c, Dec 8, 2005.

  1. ashwinreddy.c New Member

    What are the possible reasons for the Transaction Log backup to fail?

    Thanks & Regards
    Ashwin Reddy
    SQL Server DBA
  2. ghemant Moderator

    Hi,
    have you face T-Log Backup failure !? have you read Error Log and event viewer ?
    well these are some topics i found for you , please search forum also for similar topics :

    http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=58000
    http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=51363

    www.sql-server-performance.com/sql_server_log_shipping.asp
    http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/logship2.mspx
    support.microsoft.com/default.aspx?scid=kb;en-us;314515
    support.microsoft.com/default.aspx?scid=kb;en-us;329133



    Hemantgiri S. Goswami
    ghemant@gmail.com
    "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami
  3. ashwinreddy.c New Member

    hi hemant
    yes i have T-log backup failure. i have checked error log and event viewer but no reason for the backup failure.

    Thanks & Regards
    Ashwin Reddy
    SQL Server DBA
  4. ghemant Moderator

    Hi Ashwin , <br />have you refer the links i have refered ? and search in the forum ?<br /><br /><img src='/community/emoticons/emotion-1.gif' alt=':)' /><br />Regards<br /><br />Hemantgiri S. Goswami<br />ghemant@gmail.com<br />"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami<br />
  5. satya Moderator

    Ashwin
    If you have the transaction log backup inconsistency, explain the issue here to get information and if you put an open question there is no end to the answers.

    The reasons could be:
    From the last database backup or transaction log backup if there are any non-logged transactions
    or any issues with the disk resources during the log backup then the log backup will fail.

    You must look into event viewer log and SQL error log for more information on the failure.

    Satya SKJ
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page