Forum Discussion

Serge_CH's avatar
Serge_CH
Copper Contributor
Oct 18, 2023
Solved

Unable to restore transaction logs files from a specific DB

Hi, I'm experiencing a wired behavior when I restore transaction log files after I restored the full DB backup. The first log can be restored however for the second one, I get generic error telling...
  • Serge_CH's avatar
    Serge_CH
    Nov 20, 2023
    The issue was actually due to a running log backup to NULL on a secondary node, not logged on the primary's msdb.dbo.backupset
Serge_CH's avatar
Serge_CH
Copper Contributor
Oct 19, 2023
it logs all full and tx log file bkps, so it lets me check if I provide all logs to restore.
Unless sql server does not log everything there ?
Serge_CH's avatar
Serge_CH
Copper Contributor
Nov 20, 2023
The issue was actually due to a running log backup to NULL on a secondary node, not logged on the primary's msdb.dbo.backupset

Resources