Sample Header Ad - 728x90

mssql 2019 alwayson cluster backup log chain is broken

0 votes
1 answer
628 views
now i had one mssql 2019 alwayson cluster.i backup database on master node using monthly fullbackup. weekly differential backup. daily log backup. but unfortunately then backup log chain always broken include log backup and differential bakup .i check the log chain like below:enter image description here.Has anyone encountered a similar problem, is it caused by the alwayson cluster? i think Log backup after the full backup has the first_LSN value equals to last_lsn of the last log backup. It shows that log backup does not break the LSN chain and it continues to maintain the chain since the last log backup. but in my chain log backup's first_LSN value not equals to last_lsn of the last log backup. And I found that for several relatively small database , the first_lsn of the current log backup is always 100000 less than the last_lsn of the previous log backup. There are no other scheduled jobs in mysql database. Also the differential backup as well enter image description here
Asked by 王文峰 (1 rep)
Jul 14, 2022, 02:50 AM
Last activity: Jun 7, 2025, 08:05 AM