SQL Server Performance Forum – Threads Archive

Reasons for log backup to fail

What are the possible reasons for the Transaction Log backup to fail? Thanks & Regards
Ashwin Reddy
SQL Server DBA

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
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami

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

Hi Ashwin , have you refer the links i have refered ? and search in the forum ? <img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ /> Regards Hemantgiri S. Goswami [email protected] "Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami

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.

]]>