Solved

SQL database Transaction log backup is not working

  • 13 March 2023
  • 1 reply
  • 762 views

Userlevel 1
Badge +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.

icon

Best answer by Albert Williams 13 March 2023, 22:20

View original

1 reply

Userlevel 6
Badge +14

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