SQL Server Performance Forum – Threads Archive
Reasons for log backup to failWhat are the possible reasons for the Transaction Log backup to fail? Thanks & Regards
SQL Server DBA
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
support.microsoft.com/default.aspx?scid=kb;en-us;329133 Hemantgiri S. Goswami
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami
yes i have T-log backup failure. i have checked error log and event viewer but no reason for the backup failure. Thanks & Regards
SQL Server DBA
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 />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami<br />
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
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.