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 ghemant@gmail.com "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 , <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 />
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.