Skip to main content
Solved

SQL database Transaction log backup is not working

  • March 13, 2023
  • 1 reply
  • 1073 views

Forum|alt.badge.img+8

Hi Team,

 

We have facing the Issue in Our Commvault backup infra,

 

While running the SQL database transactio"n log backup  we are getting the belo error

“Broken chain detected for database ,Automatically converting the backup to full”

Please advice on the above issue.

Best answer by Albert Williams

Hello @Adarsh.op 

 

Thanks for raising this question with us and choosing Commvault!

When a T-log job runs in CV we will take note of the last Log Sequence number ( LSN ). When the next job runs we check the first LSN to validate we are still backing up t-logs in sequence. If we detect that this chain is broken then we convert the backup to a full as a broken chain results in useless data. 

 

There are a number of reasons the chain can break but the most common is that the DBA team is performing some kind of interactive backups outside of CV resulting in t-logs being cleaned up and breaking the LSN. 

 

If you are still having issues i would recommend a ticket and we can review from a support side with more context. 

 

Kind regards

Albert Williams

View original
Did this answer your question?

1 reply

Forum|alt.badge.img+15

Hello @Adarsh.op 

 

Thanks for raising this question with us and choosing Commvault!

When a T-log job runs in CV we will take note of the last Log Sequence number ( LSN ). When the next job runs we check the first LSN to validate we are still backing up t-logs in sequence. If we detect that this chain is broken then we convert the backup to a full as a broken chain results in useless data. 

 

There are a number of reasons the chain can break but the most common is that the DBA team is performing some kind of interactive backups outside of CV resulting in t-logs being cleaned up and breaking the LSN. 

 

If you are still having issues i would recommend a ticket and we can review from a support side with more context. 

 

Kind regards

Albert Williams


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings