SSMS 16.5.1 - Restoring database is slow
I saw a significant performance decrease after updating to the latest version of SSMS (16.5.1). Loading a backup file and going through the tabs/pages with the options in the "Restore Database" window takes WAY MORE than one minute, when before the update it took 1 second or less.
This only happens after selecting the backup (.bak) file.
AdminMicrosoft SQL Server
(Product Manager, Microsoft Azure)
shared this idea
This is a long outstanding issue (I’m sure we have duplicate reports elsewhere, like 32900767 and 32899099).
We think we found the root cause and hopefully a fix will be made available in the next release of SSMS.
Thanks,
-Matteo
2 comments
-
pbradshaw
commented
This is fixed in version 18.3.1+
-
pbradshaw
commented
This has just been getting worse and worse. I just installed SSMS 18.0, and now clicking "..." to select the *.bak file has been hanging for 12 minutes. This isn't usable.