Restore database from device doesn't work in SQL Management Studio

Restore database from device doesn't work in SQL Management Studio

  • August 23, 2019

Recently I was running into some strange behavior of Microsoft SQL Management Studio 2018. I was going to restore a simple SQL database from a backup file, using the Restore Database Wizard. Something I've done dozens of times without any problems.

This time the wizard stopped responding and never continued to work again.

So the thing I tried to achieve was:

  • Start SSMS
  • Select Tasks -> Restore Database
  • Select From Device
  • Click the Browse button

At this point SSMS stopped responding and I couldn't continue.

Solution / Workaround

It seems that this behaviour only occurs when you do this from a specific database node. If you access the wizard from the Databases node, it works without a problem!

Restore Database
Restore Database







Image Description

Entrepreneur, Senior Software Engineer .NET, Sitefinity Solution specialist, Orchard CMS enthusiast, Product Owner

All Author Posts

Got another minute? Check out:

Image Description

Call us

+31 (0) 36-2000196
Image Description

Address

Grote Beer 57, 3893 DJ Zeewolde
NLThe Netherlands

Please sign in

Signin to manage your account.

Do not have an account? Signup

OR