SQL Server Management Studio: Restore Database from Device HANGS on clicking "..."
When I wish to restore a database from a .back file, I go into SSMS, select Tasks->Restore Database, and on the dialog, I click the "From Device" radio button, and then click the "..." button to browse to the .bak file I wish to restore. This then HANGS for MINUTES before the "select a backup device" dialog appears and allows me to drill down and select the backup file.
I have literally HUNDREDS and HUNDREDS (maybe THOUSANDS) of *.bak files on a big data drive with lots of folders. It seems like it might be trying to iterate over all of them and pull information from each file before displaying the dialog. Just a guess, but I can't imagine what else it's trying to do. And it shouldn't need to do that.
It's pretty much unusable. I have to click the "..." and go get like three cups of coffee before it returns and I can continue with my work.
Please, try SSMS 18.3.1+
This should be fixed.
Chris Webb commented
As per the suggestion by Ivo B if you right click on the Databases node rather than the actual database and then select restore it works fine without hanging
Work Around is to make a dummy back up of the DB you want to restore into.
After that when you run the restore db just remove the dummy backup set and hit the ... to the db file you actually want to restore. it not longer freezes.
Still happening with V18.4. Why is it set to completed? It's not fixed
Diego Esteves commented
Estava com o mesmo problema, SSMS 18.2, não abria nunca a janela para restauração de banco de dados.
Consegui abrir a janela para restauração seguindo a dica aqui do fórum:
criei um backup do banco novo vazio, após fazer isso, consegui restaurara qualquer arquivo .bak.
Ivo B commented
You can avoid this problem by right clicking on the Databases node and choose the restore option from here, instead of choosing the restore option on the database itself. Works the same, but without the freeze.
Back again for me too as of 7/1/2020
Problem is back in 18.4
++Anthony. Backup the empty db first.
Adrian Evans commented
I installed 18.4, but also did a backup of the company before I tried restoring, it is as though the system tries to look for back-up files and hangs if it doesn't find any if you have never done a backup of the database.
Just updated to 18.3.1. SSMS freeze then click on Add button. Can't get any select dialog at all...
Neil Leininger commented
It is not fixed. Downloaded 18.3.1 this morning and the problem is still present.
I have tested, and it's fixed. HALLELUJAH!!!
What I do for this is when the empty database is created. do a backup of the empty database, and then it worked with no issues.
I regret upgrading, taking ages for source->devices dialog to open(still not returned) and I have but 1 database. v15.0.18142
I have the same issue and I have only TWO .bak files
SQL Server Management Studio 15.0.18142.0
Same issue here (running SSMS v18.2) ...
I'm having the same issue. SQL 2018 on Windows Server 2016. New Install. Only 3 files in the backup folder. Does the same if I have no files. Is there a fix yet?
I was able to restore DB after I did dummy backup in the different folder then default, then the restore of a backup I needed was successfull.
Mohanjana Dissanayake commented
I have change the permission to database default backup location and issue was fixed.
I have the same problem on Windows 10 on Parallels with Microsoft SQL Server Managament Studio 18.1. When I click ... to choose device Restore Database Dialog freezes.