SSMS 18.5 not showing manually backed up files when using restore menu

• sqlfriend

  SSC Guru

  Points: 52769

  More actions

  June 8, 2020 at 11:30 pm

  #3761525

  I am using SQL server 2017. SSMS 18.5.

  1. I did a full backup of database manually for databaseA on SSMS on my workstation.

  2. Then I tried to restore the databaseB from the backup of DatabaseA I just did.

  3. From the restore menu of SSMS, in the backup restore sets list window, I cannot see the backup I just did in 1. It listed those backed up earlier through sql agent job.

  4. But on my server I have SSMS 17.5, I remote into my server and I  went to the same restore window, and I can see the backup created in 1 was listed there.

  5. if I restore from device, and browse to where the backup file is,  the restore works that way too.

  What could be wrong about 3.

• Site Owners

  SSC Guru

  Points: 80320

  More actions

  June 10, 2020 at 12:10 am

  #3761840

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.