Post reply

SSMS 18.x cannot find right version of most recent backup

  • May 12, 2020 at 4:46 am

    #3750653

    I used 18.4 , from the menu,click restore database, it lists the full backup two weeks ago, but we actually have this weeks backup, for some reason, it cannot pull the most recent. On another computer with SSMS 17.x, it pulls correctly.

    Is it a bug somehow?

    thanks,

     

  • May 12, 2020 at 2:35 pm

    #3750813

    Haven't heard this, but it's possible. I doubt it, but can you do two things.

    1. Put 18.4 on the computer with 17.x that works.
    2. Put 18.5 on this computer and see if things change?

  • May 12, 2020 at 3:37 pm

    #3750848

    Good suggestions. I will try that.

    The restore wizard pulls the backup that I did manually earlier,  it is in the msdn database.

  • May 12, 2020 at 3:46 pm

    #3750850

    I just tried the restore  steps on another server with 17.4 installed, it restored the  correct version.

    And then I  tried on another server that  has  SSMS 18.4 installed, it restored the wrong version.

     So I am still suspect this is a bug  in 18.x.

     

  • May 12, 2020 at 3:52 pm

    #3750851

    Note the wrong version it pulled is a full backup I did manually , not the sql agent job triggered jobs.

  • May 12, 2020 at 4:32 pm

    #3750866

    Could it be a copy only backup?

  • May 12, 2020 at 4:41 pm

    #3750867

    No it is not a copy only backup.

    What is  the strange thing is I query the  backup history, the older one is no longer in msdb database, for we purge backup every 3 weeks, so the 4/8 backup record no longer in backup history table. But it still shows in the restore wizard list.

    The backup file is still there, I stored in another directory.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply