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
olafhelper's avatar
olafhelper
Bronze Contributor
Oct 19, 2023

 

Serge_CH wrote:

... which in fact does not exist.

Serge_CH , "does not exists" means what; somehow deleted?

You can't restore what not exists and if SQL Server says, there must be one, then there should be one.

  • Serge_CH's avatar
    Serge_CH
    Copper Contributor
    Oct 19, 2023

    olafhelper  This is true however msdb.dbo.backupset records the bkps and I have all of them available unless a bkp could be done without being recorded in msdb.dbo.backupset

    • olafhelper's avatar
      olafhelper
      Bronze Contributor
      Oct 19, 2023
      What has "msdb.dbo.backupset" to do with your restore? ... beside that SSMS uses it to suggest a restore file chain.
      • 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 ?

Resources